« Online Time Clock MTS Database Server Problems | Main | Online Time Clock MTS Database Server Problems Part 3 »

November 13, 2010

Online Time Clock MTS Database Server Problems Part 2

Well yesterdays fixes to the Online Time Clock MTS customer data servers worked beautifully. But unfortunately the OTHER database server containing all of the actual account login data decided it was overloaded and shut itself down for a couple of hours. This was in the middle of the day US Central Standard Time. As a consequence I've spent several hours today optimizing most of the database access routines Online Time Clock MTS uses to minimize the load on all our servers. The number of times the system accesses the database servers has pretty much halved and the quality of the requests for information from those same servers has improved greatly. A big plus to this is that access speeds have improved considerably and a number of reports appear to be running nearly 4 times faster than before.

The final step in this process is to setup a dedicated computer that will ONLY be serving up data to the Online Time Clock MTS system. I'm expecting this to come on-line in the next 24-48 hours and this will eliminate the growth pains we're experiencing right now. Online Time Clock MTS was designed for this sort of growth, but the time to expand came a lot quicker than what I was expecting. Many apologies and thanks again for your patience through this time.

Posted by markn at November 13, 2010 1:18 PM