I do not think this slow page loading is a dog of a server issue, i think its got something more to do with the attributes sql code

I have a test site online here

http://www.specsellers.com/spec2/index.php

and for most all pages the page load is sub 1 sec, all products lists , category listings etc etc

yet

the product page, stalls at the attribute loading and takes about 15 secs..

i set the page load time and quiries run to show at the bottom of the page, and its showing sub 1 secs for most all pages and 200 or so qeiries..

yet the product page takes 15 secs with 11000+ queries..

now i know there are a lot of options, but thats because of the specifics of the lenses in the orders

why does the system make 11000 queries?

i have 1 option with 180 items in the dropdown, two others with 50 in the dropdown, and two with 20 in the drop down, but this shouldnt be 11000 queries.

something isnt right and i would say its the attributes sql code..

ok,

why can i rule out my mysql, well the same apache/php/mysql combination server 45 other sites and none have issues, one of the sites does full text searches in multiple ways through 560,000 records in a 258mb mysql database, and it runs no hassle, i have postnuke site, phpnuke, joomla and wiki's and all run sub 1 sec pages, yet my only zencart runs cool untill the product page

anyone any idea's


Steven