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)