Serious Delay Loading Pages

[rotozuk]

Ajeh,

Thanks for the fast response! I have found the Dreamhost threads.. Bummer.

I turned on GZip and turned off "upcoming products" and some other little tid bits I found in threads here. It probably loads about 1 second faster on product pages, but still 6 seconds too long.

Thanks again!

-Wayne

[polarduality]

Dreamhost is not Zen Cart friendly.
I recently switched a client from Dreamhost to a new host because of this same issue.

[Ajeh]

Nothing in your shop accounts for 6 seconds ...

NOTE: a site that has not been touched ... as in no one has visited it for XXX amount of time, this is server dependant, does have MySQL queries that are not "stored" or preloaded by other users and there could be a delay ...

What this means is ...

Let's say I come to see your site today and am 1st in the door ...

I hit the All Products link ... and say this takes 6 seconds ...

I then click Page 2 of All Products ... and let's say this is 6 seconds ...

I then click Page 3 of All Products ... and let's say this is 6 seconds ...

Now I click back to page 2 ... and it takes 0.2 seconds ...

This is cached queries are not helping make the site fast ... some sites use this ... some do not ... others have it set very low ...

Now if each page regardless of going:

All Products Link
Page 2
Page 3
Page 2
Page 3

are always the same slow time ... then you have a dog of a server as your hosting site is not even attempting to optimize things for MySQL ... or the settings are too low and you need to talk to your hosting site and get them raised ...

Active sites have the advantage of more things are cached in the MySQL to keep things running fast ...

I am not a server type ... just talk to my hosting guru to understand how it is his servers are so fast and become faster with each click ... and the next guy in gets the fast queries that I made by looking around the site ...

Hope this might help too ...

[Ajeh]

NOTE: unfortunately ... this is not the issue on your site ... it is just a dog ...

[rotozuk]

NOTE: unfortunately ... this is not the issue on your site ... it is just a dog ...

Bark bark..

Yep, I'm thinking of breeding it and getting some puppies.

Surprise, surprise, mo response yet from Dreamhost. I checked our account and we still have 6 months pre-paid there.. I thought we had longer, so not as bad of a hit. Looking close at one of the Zencart hosting companies.

-Wayne

[StevenD]

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

[Ajeh]

StevenD ...

With the 400+ attributes per product this will take some time to load ...

In the next couple of upcoming releases this should help you quite a bit ...

I would be interested in a copy of your database to work on further optimizations as your site definitely pushes the limits and would be of great help in testing the new versions before release ...

If that works for you ... please drop me a PM ... thanks!

[Ajeh]

NOTE: you have a nice fast hosting site ... many cannot manage 80-100 attributes in 15 seconds let alone down to 2 seconds or less ... where a good server should be at ...

[StevenD]

Linda, I sent you a priv message

you know what would be really cool, if there was an option in the option types for html or code

where we can now choose, radio, text, dropdown..

there should eb a code/html custom option

then i could choose that, for the size range

and in the custom code add

<?php
$i = "-60";
while ($i <= 60):
   echo "<option value=$i>$i</option>";
   $i++;
endwhile;
?>

and then my options would show the +60 to -60 dropdown, without even having to add all the damn attribute options one by one in the firstplace, and it would also allow for a single sql to get that code statement rather than hundreds for all the options one at a time.

or even of it allowed a custom array to be typed in and then displayed through the same place

you could choose 'array' instead of text, radio, dropdown

and then just type an array of dropdown choices into the attribute section where it asks for rows, etc

1,2,3,4,5,6

or

Blue. Red. Green, Black

whatever

it would speed up the adding of certain attribute/option types, and cut down on sql calls

Steven

[rotozuk]

Since I see some people linking to my site from this thread, I should point out that I switched hosting over to one of the Zen Certified companies, so it is nice and speedy now. Also offers more features then dreamhost.

I was happy at Dreamhost until this issue came up, now I'm even happier. :)

-Wayne