Hi there,

I have been using ZC for over 2 years and love it. I have a multisite module and have approx 2300 products across 3 stores. We also have a custom built tartan database and have the query cache module installed.

Normally, performance is somewhat sluggish (2-4 seconds for a page to load), however, for some products with a lot of attributes (such as this item) take significantly longer. I'm aware that it has a lot of attributes, and that is a known issue, however, adding this product to the shopping cart takes approximately 40 seconds to load but only 8 seconds of this is used up running database queries (to the best of my knowledge).

Further to that, some products such as this one have a lot of queries with a longish response time: Parse Time: 4.591 - Number of Queries: 639 - Query Time: 2.7954458689118

Our site is hosted on Media Temple's Grid Service, currently with their top level MySQL grid container, so the MySQL performance should be adequate.

I'd be grateful for some information on how we can improve the site performance. Is it simply a hosting issue? Would a dedicated server make much difference? Should we focus on reducing the number of database queries?

I read somewhere about some product pages only initiating 10-20 database queries - I would love to get to that level!

Also, if anyone is able to offer some help on this on a professional basis, please get in touch.