Dong Shin 06.26.2014

  • tried to deploy the new Query Builder, the queries are too slow… 6 minutes! will try this tomorrow
    • ‘Copying to tmp table’, ‘2.432915’
      ‘Sorting result’, ‘0.899327’
      ‘Sending data’, ‘0.783034’
    • SHOW VARIABLES LIKE ‘max_heap_table_size’;
      • ‘max_heap_table_size’, ‘16777216’
    • SHOW VARIABLES LIKE ‘tmp_table_size’;
      • ‘tmp_table_size’, ‘16777216’
  • added last COGNOS upload status to FA
  • added status (Red, Yellow, Green) to Obligated, Outlay, PM Actuals % value columns in Query Builder (old)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: