Dong Shin 06.19.2014

  • did some performance testing of the temporary table, __view_project_detailed_data
    • data generation took 90 sec
    • query is faster
    • need Update button in Query Builder when data generation is needed
    • installed MariaDB and compared the performance
      • data generation too 20 sec
      • some error running stored procedure… may need to run – mysql_upgrade.exe -uroot -p –force 
        • #1728 - Cannot load from mysql.proc. The table is probably corrupted 
  • working on Query Builder
    • added Update Data in Query Builder to update project detailed data
    • added _table_last_update_status to keep track of tables status
    • added triggers to update the _table_last_update_status – obligations_outlays, budget_centers, committed_amount, and contracts_cognos for now
    • modified users queries to match new structure of __view_project_detailed_data

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.