News from Timesheets MTS Software: January 2013 Archives

Add / Edit Time Screen with Colors!

Happy New Year to all Timesheets MTS Software Blog readers! I've taken the opportunity given by the usual slow Christmas/New Year period to spend several days working on Timesheets Lite. I added a few new features in this release but most of the time was focussed on performance issues for users with very long project and employee lists. It was an interesting exercise that taught me two things. First, I am kicking myself for the truly dumb ways I tried to handle large datasets and the impact this had on performance. Second, I am amazed by some of the performance improvements I've managed to eke out. The best improvement is in the speed of display of the Employee Login Screen. Testing against my reference database gave a loading speed that was 80 times faster than previous versions.

Anyway, enough chatter, here's the details of all the changes.

• Common activities can now have a fore and back color. These colors are visible on the Manage Common Activities screen and on the activity drop down on the Add/Edit times screen.
• Project fore and back colors are now displayed on the project drop down on the add/edit time screen. See the screenshot above for what the add/edit time screen can look like.
• Use Non Billable Fields checkbox added to the Interface Options screen. When checked employees can mark a time as non-billable and will see a non-billable column on the employee timesheet.
• Project colors are applied correctly to the Manage Projects screen after an existing project's colors are changed.
• An internal system has been added to allow the addition of new tables and columns to the Timesheets Lite database.
• Much time spent working on the load speed of the employee login screen. Good performance improvements seen.
• Internal loading speed of employees improved greatly. Should reflect in better report generation times.
• Much time spend working on the Add/Edit Time screen for users with very long project lists (1000+ projects). Much of the data is now cached or pre-emptively loaded. While the first load of the Add/Edit Time screen may be a little slow for very long project lists subsequent loads will be much faster.