Problem

Part of the company’s franchise management system was a truck scheduling calendar that ran
painfully slowly causing system slow downs on the server. Hundreds of technicians used the calendar daily
and the frustration of delay and system crashes caused no end of support calls.

Action

A review of the code generating the schedule revealed nested loops that caused excessive
memory usage and calls to the database engine. A simple easily missed design flaw needed fixing.
The code was re written and tested in the staging environment and then for a single user on the
production server. Review demonstrated that the changes made the scheduling calendar run over 100 times
faster.

Solution

The solution was put into production for all users. In the words of the technicians and owners
the change was like going from dial up to high speed internet.