Tested Texas drivers license system which logs into the Texas website to purchase and download customers drivers license printout.
Re-write sql and display for the student search results page. This page was original to the system and used a loop wend, now changed to an array also had a number of joins which I have reduced. Now the page displays nearly instantly.
Optimized sql on the 8 Arizona Control Panel so that the counts that display on the navigation bar are now all in one sql statement. Was still too slow, moved it into a view.