Serious Delay Loading Pages

[groovix]

Ajeh: I'm not sure if this is what you mean, but here are the Configuration->Sessions settings from the zen cart admin page:

Sessions
Title Value Action
Session Directory /home/jbpardee/public_html/store/cache
Cookie Domain True Info
Force Cookie Use False Info
Check SSL Session ID False Info
Check User Agent False Info
Check IP Address False Info
Prevent Spider Sessions True Info
Recreate Session False Info
IP to Host Conversion Status true Info

CFE:I have not hand manipulated any tables. drbyte offerred to look through my database so maybe he'll find something there.

[Ajeh]

I am thinking some of the speed issue will result in missing indexes on your tables that DrByte should hopefully be able to get back on track ...

But, the bulk of the issue is the attributes ...

If you are not using a good server configuration ... you will run like a dog with a server that is not designed to give you optimal MySQL settings ...

If you were to go to phpMyAdmin and look at the products_attributes table ... then do a search for products_id 23 ... how many records are found?

[StevenD]

I believe that blaming the indexing in not the issue, the indexing should be taken care of in the database installation, their should be no reason to alter it afterwards, if thats the case the initial installation of the zencart db is wrong.

I have looked hard at the slow loading pages, Linda, i did send you a copy of the database from the glasses site, I said in that email that i believe its all down to the attributes code itself

As soon as any page has more than a normal ammount of options in any dropdowns the pages slow and in my own case almost stop, curl up n die.

I have been playing with other shop scripts and have found the fastes to load my 300+ dropdown options is agoracart, it loads the products page in about 1 sec, against 15 to 70 secs with zencart.

its not my mysql server, its not my apache, its not my hardware, as i said in an earlier post, i have 30+ other domains on that server running everything from joomla sites, to postnuke phpnuke oscommerce zencart and custom php+mysql, and everything runs great.

Infact zencart runs great, untill you open the product page.

Linda, when you asked for the copy of the database you mentioned a newer better configured optimised zencart codebase that was due out, whats happening with that code, is a trial available anywhere.

Because as it stands, i honestly believe everyone is blaming server configs, mysql installs and configs, and noone is prepared to officially go on record and say that its the attribute code which is the cause of all the problems

StevenD

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