How can you manage the size of the database in the SmartLog Pro® Manager Web App to improve speed and performance?
How can you manage the size of the database in the SmartLog Pro® Manager Web App to improve speed and performance?
Here are some tips for dealing with large databases:
Use the Database Purge feature in the Options to reduce the size of the database. Evaluate how much historical information you really need to keep and and adjust the setting to purge data older than the number of months you specify.
There is also an option to set a Database Size Alert to appear in the main screen of the software as a warning once the SQLite database reaches a specific size. This alert will not work if using a SQL Server database of your own.
Disable the Operator Last Known ESD Status widget in the Options, so it does not appear on the main splash screen of the program. This will reduce program requests sent to the software and testers. If you use this widget, you may want to adjust the value for its refresh option to a longer time period to help with performance.