Serious Delay Loading Pages

[Ajeh]

Turn off the calculations that are not needed ...

That is the biggest problem ... on attributes ...

Hosting is often the issue on sites with 20 or less attributes ... never should you see dog sites for that ...

50 to 80 attributes can still run well on a properly configured site ...

Your site is extream ... which is why the need to gear the attributes differently is so important ...

300 attributes doing calculations you do not use ... that is the issue ...

[StevenD]

unfortunatly there are no options that can be turned off, all are needed

because the glasses options will be chosen from details a person will have on a prescription form saying what their eye details are, left and right eyes will probably be different, and the options have to be chosen from the drop down, rather than just inputted into a text box, becuase otherwise if the person reads a hand written prescription wrongly, ie misses the .(dot) out of 1.25 calls and checks have to be made to see if it was 1.25, 12.5 etc etc, or at worst glasses could be made and then delivered and arrive wrong because of a wrong number entered, using drop downs means they have to enter in the format wanted, also allowing for ~ infinity etc..

so loosing a few options isnt an option (no pun intended )

how do i get a copy of any newer improved zencart code to test?

StevenD

[Kim]

Sorry- but you will get it when everyone else does. When it is finished and released.

[Ajeh]

StevenD ...

I have your database loaded in v1.3.0.2 on my site ... I have changed nothing to the database, indexes, etc. I have not attempted to speed up anything at this point ...

Your products_id 12 that takes first hit on your site:

Parse Time: 54.619 - Number of Queries: 11924 - Query Time: 51.87784507579

And your site 2nd hit takes:

Parse Time: 54.164 - Number of Queries: 11934 - Query Time: 52.863686105011

Loads on my site first hit:

Parse Time: 6.036 - Number of Queries: 11930 - Query Time: 5.19674339697

Second hit:

Parse Time: 5.477 - Number of Queries: 11946 - Query Time: 4.66335187886

Servers can make a lot of difference ...

I will check indexes later when I have more time ...

I will PM you access to this site for you to review your products on a my server ...

NOTE: The products tested have approximately 539 attributes each ...

[Ajeh]

Oh and I forgot ... the server is:

Model Intel(R) Pentium(R) 4 CPU 3.20GHz
Chip MHz 3192.09 MHz
Cache Size 512 KB
RAM is 2 GIG

[Shara]

Ok, I'm not trying to open an old wound, but I run 4 zen-cart sites that have long lists of fragrances. Some products can have 200+ choices in several categories.

I recently upgraded one store to v1.3.5 from a version from last year. This site is now having problems with the attributes and is sooo much slower than before and those that are still running older versions.

I believe that a bad hosting server could be a problem, but this is the same server as I've used for years, the other stores are not having a problem. It only comes to mind that it could be possible that the attributes module is not working as efficiently as it should?

I don't want to get into a spitting match about server settings, indexing or any other stuff I just wanted to put in my two cents and will wait patiently for an update, but only if I know one is coming. Otherwise I have to find another solution for these products.

Is this something that is being worked on?

Thanks.