Ok, I've finally made some progress.
I remembered that in my dark days of X-Cart administration I would do a SQL export/import when things got real laggy and it would help for awhile at least. I've done this with www.giggles.com and I'm now seeing parse times of under a second.
Parse Time: 0.592 - Number of Queries: 162 - Query Time: 0.0749620353241
Parse Time: 0.779 - Number of Queries: 269 - Query Time: 0.114330349075
Don't know what magic that does to the DB, maybe reindexing?





