I have been working on optimizing the MS2 codebae for several months and am going to do a test site from scratch so everyone can follow along.
This is my development server and I'm going to keep the admin area open for everyone. Don't mess this up with malicious stuff or I'll lock it down.
On the bottom of every page there is a debug output with parse time, query count, and the actual queries used to construct the page. I'll be using this info to optimize the queries.
Can anyone take a look and see any redundant queries? It's a loaded question since I've already been down this block and know where there is opportunity to streamline. Let's see if anyone wants to follow along as we get this down to 10 queries per page and sub .1 second render times (read: bad ass cart performance).
The only requirement to the optimizations are a net increase in performance and NO LOSS OF FUNCTIONALITY.
Vanilla Install Stats:
Parse Time: .328 seconds
Queries - 92
Disable Category Counts:
Parse Time: .259 seconds
So, save 40 queries right off the bat for disabling category counts.
More optimizations tomorrow...whe I start to dissect the code and get this puppy screaming.
Edited by sparky, 07 January 2005 - 12:41 PM.