So, I have a few customer's website with a great deal of attributes, but under 700 products each. One is 1.5.0 (with Data Digger Query cache installed, but upgraded for 1.5.0) the second is 1.5.1 with the built in caching.

The sites are just too slow.... here are some query examples

1.5.1 site
First load Parse Time: Parse Time: 0.693 - Number of Queries: 459 - Query Time: 0.243524054993
Second Load: Parse Time: Parse Time: 0.609 - Number of Queries: 458 - Query Time: 0.149512161057
Google PageSpeed Score 92/100

1.5.0 site
First load Parse Time: Parse Time: 0.644 - Number of Queries: 86 - Query Time: 0.101940719681
Second Load: Parse Time: Parse Time: 0.310 - Number of Queries: 94 - Query Time: 0.0615120733185
Google PageSpeed Score 91/100

Both sites hosted on the same server.

An example site (1.5.0), also hosted on the same server, which has few or no attributes
First load Parse Time: Parse Time: 0.212 - Number of Queries: 60 - Query Time: 0.0433254337006
Second Load: Parse Time: Parse Time: 0.188 - Number of Queries: 61 - Query Time: 0.0314254791107
Google PageSpeed Score 88/100


My question is what changes, besides these (http://www.zen-cart.com/content.php?63) which are already done, can be made to improve query times as well as caching? Any suggestions?