Serious Delay Loading Pages

[Ajeh]

I am working on making a faster and better method ...

However I have had issues that do not afford me the luxury of fixing this in all my free time right now ... as I don't have much of it ...

I had a lot more before we got flooded out and I am just catching up ...

So if asking you a few questions is too much for you to answer in the meanwhile ... I am sorry that I cannot help you right now ...

I will be trying to get back to the database fixes as soon as I can and any code changes that can help ... but I only have 10 fingers and 10 toes and someone went and only put 24 hours in a day ...

[Merlinpa1969]

StevenD,

I can understand your frustration, however I can tell you that the server has alot to do with the issue,
if you are running 30 or more sites all using mysql, and there are other resellers on this same server. you can see where there might be a bottle neck somewhere.

now with that out of the way,
Zen cart is a pig for resources on attributes, this has been stated by lots of folks,
but with a few tweaks, and setting the indexes accordingly, Yes in older versions of zen cart this was NOT done in the install ( it is now )
it will speed things up,
I believe Sashbox.com has several examples of zen carts on his main page and if im not mistaken several have loats of attributes.

so just blaming it on zen cart is not a true statement either,

its a combination of both.

in regards to the other carts mentioned do they other the range of services for attributes that zen cart does?


On this last Im not being a smart@$$ I am genuinly curious.

[Kim]

Steven-

If you will look at the roadmap, you will see that the next major release contains MYSQL Query Optimization. Until then, take Linda's advice and add some more indexes and make sure your server can handle the load.

[StevenD]

here is a link to a php/mysql page, its very basic, because it is just a search system, nothing special

http://dowd.info

the 1851 database and the other tables off that page make up a 250 megabyte mysql database, how 500,000+ entries , its searchable in many ways, and the pages load in no time at all.

the server this site is hosted on, is a quad dual core amd, 12 gig ram etc etc etc..

I know for a fact what other sites are hosted and what isnt, the server is not an issue, the mysql is the same mysql server as my zencart , the apache the same, the php the same.

the zencart runs crap,

it runs fine, on all pages, untill you have to open the products page with all the options

here is a link to two test sites. which i have tried these options

click this first

I am sure that page would have loaded ok, it has roughly 300+ option attributes in the drop downs.

click this second


This is the same glasses in a zencart products page, roughly same overall options in the dropdowns, just not formatted into the same layout, i didnt want to spend anymore time than about ten minutes on the agora cart system untill i was sure it would load the pages.

if you click the view all products pages in either cart, zen or agora, the load at about the same speed, zencart only struggles at the attributes pages.

ok, i realise that agora is cheating and not a fair test as it uses includes of a html template for the options, but real life has to kick in, and say that at the moment, zencart has major issues with its products pages if their are more attributes than basic choice of a few red, blue, black type options

its because i have so many different perfectly working installations of different php+mysql code systems in my same server, that i can say with more confidense than most, that it IS zencart which is at fault, not the mysql etc..

and i do not see any problems with the index's, thats not the issue, the issue is that the products page makes to many seperate quiries, for my products page it makes 11,000+ seperate queries, why the hell doesnt it just ask to select * from xx where y=z

why the hell 11,000 times for 300+ options.

ok, my page is extreme i accept that, but by being extreme it has shown up, how bad the system is, when your normal 5 option dropdown page makes 400 queries something is wrong.

dont blame the hosting or index's, it should be faster than this even if their was no index.

Steven Dowd

[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.