I've spent most of the last week working on improving the performance of Timesheets Lite when it's using a network shared Microsoft Access database. Version 3.5.0 is the result. Here's a list of the changes in this new release:
- Much data on the Add/Edit Time screen is now pre-emptively cached to speed up loading.
- Many hours spent improving performance of the timesheet display when multiple times are displayed (think the unlikely case of 50+ times in a single day).
- Much time spent optimizing the process for loading large collections of times. This should result in much improved performance right across the whole program.
- Much time spent optimizing the time data object to pre-emptively cache project, employee, and activity data. Again should result in improved performance.
- Several single table queries have been replaced with cross tab queries to reduce the number of database accesses. Again, should result in program wide performance improvements.
- Most of the queries used by the employee timesheet report have been optimized or changed to cross table queries to speed up report generation.
- Time spent on the generation speed of the Detailed Activity report.
- Filter text box added to the Manage Projects screen.