- 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
viztales
Dimension reduction, State, Orientation, and Speed
viztales 