As users of Timesheets Lite prior to version 3 start using the new version they've highlighted some issues with the software dealing with larger databases (think 5-10 years of historical information). With some help from these users we've managed to track down and address a number of performance issues in the last week. These have been incorporated in Version 3.3.0 of the software which is now available on the web site. Here's a detailed list of the changes made.
- Completely changed the database connection routines which copes much better with larger data sets. This should fix up the "cannot open more tables" error that was seen from time to time.
- A lot of time spent optimizing load speeds for large project/time/employee record sets.
- Significant load speed improvements on all manage data screens, the add/edit time screen, the report configuration screen, and the invoicing screen.
- Some more fixes for the import data wizard.
- Removed the tooltip popups from various lists which has improved load speed considerably.
- Busy cursors added to various areas of the program including loading data on the manage data screens and the report configuration screen.
- Timesheet column widths are now remembered properly.
- Timesheet column order is now remembered.
- Fixed the last column of the Two Week Timesheet report which was not displaying the time format correctly.
- Added an "All Dates" option to the report configuration screen.
- Added the period dates to the summary lines at the bottom of the timesheet.
- Changes to the "Show Activity Column on Timesheet" now takes place immediately rather than on software re-start. .
- Timesheet totals at the bottom of the timesheet are now for the month/week of the currently selected timesheet day rather than for the current calendar month and week.
- Fixed the common activity report which was not displaying correctly if there were more than 7 activities defined.
- Updated the tips.txt file.
- Added catch to allow exiting from the software if the timesheet summary thread doesn't ever exit.