I've thought my site is not as snappy as it should be and turned on parse & query settings.

I have a store with 8 categories. When I look at a category with 27 products in it I get the following.

Parse Time: 14.293 - Number of Queries: 1090 - Query Time: 12.863866250931

1090 queies to display 27 products ?(!!) 14 seconds to load a page??

Do inactive categories, products and specials count?

I asked my ISP about db performance The tech randomly clicked links and got 0 query times. He didn't click the same link described above AFAIK and I've asked for access to the slow logs myself

But on NONE of the pages do I get 0 query time per the numbers at the bottom of my pages. So I wonder what's going on and why slow logs show fine performance, but the parse/query time of ZC shows pretty poor performance IMO.

I have reviews, right EZ-pages, specials (none now active) bestsellers boxes) activated. I think that's pretty minimal.

Thanks for clarifying