Pages loading very slowly

[Ajeh]

Are you able to go to phpMyAdmin and export the structure of your database then Zip that and add it as an attachment ... the goal here is to perhaps find missing indexes ...

I have 3 Option Names each with 1700 attributes on it and have the query times of:
Parse Time: 2.357 - Number of Queries: 3824 - Query Time: 1.3687172103424

I have not tested this with the 5100 attributes on other servers, but I have with 1700 Attributes on Products and I do not get 12 seconds ...

If you look in your Zen Cart Admin at the Tools ... Server Info ... what do you see from just below the menu and up to and including the php version?

[lat9]

I'm going out on a limb here, but I'm guessing that you've got "Dynamic Product Updater" installed. When I look at the Firebug "Net" tab on Firefox, it seems that a lot of time is spent posting to dpu_ajax.php.

[sports guy]

lat9: Yes I do and always have had dynamic price updater. Many of my attributes are dependant upon that module.

Ajeh: First here is my server info:



Second: I have added my database (exported the structure of my database then Zipped it and added it as an attachment)

[lat9]

lat9: Yes I do and always have had dynamic price updater. Many of my attributes are dependant upon that module.

Is there a way to (momentarily) disable the DPU to see if that's the bottleneck?

[Ajeh]

So much for that theory ... you have the indexes expected so that is not it ...

[lhungil]

With JavaScript enabled I am seeing "NetworkError: 403 Forbidden - http://www.framesforlife.com/images". So something in your JavaScript is attempting to access this location (and the site is configured to deny access). This will slow down apparent load time for the site (why is it trying to load something which should not be loaded?).

But the "meat" of what I am seeing is the product page "seems" to hang when attempting to generate the "product" content (div id="productGeneral"). Can you enable page parse times so we can see how many SQL queries are involved and an overview of how long they are taking? Feel free to modify your template to output these as a comment (so web browsers do not actively display the parse times to potential customers - or mess up any CSS layouts).

[sports guy]

With JavaScript enabled I am seeing "NetworkError: 403 Forbidden - http://www.framesforlife.com/images". So something in your JavaScript is attempting to access this location (and the site is configured to deny access). This will slow down apparent load time for the site (why is it trying to load something which should not be loaded?).

But the "meat" of what I am seeing is the product page "seems" to hang when attempting to generate the "product" content (div id="productGeneral"). Can you enable page parse times so we can see how many SQL queries are involved and an overview of how long they are taking? Feel free to modify your template to output these as a comment (so web browsers do not actively display the parse times to potential customers - or mess up any CSS layouts).

I don't know how to troubleshoot the javascript getting hung up on the images folder. But I do have additional product images and image manager installed. So perhaps this is leading to this javascript snag. Some of my product pages (like the one above) have an additional image and others do not.

I enabled: Page Parse Times.

[sports guy]

Is there a way to (momentarily) disable the DPU to see if that's the bottleneck?

I removed the 3 files for Dynamic Price Updater and was getting the same slow load times as my other tests (8 - 9 seconds at this time). Did several tests on multiple products and the same result with or without dynamic price updater. So the dynamic price updater seems to be working fine. In fact, it seems to load quickly once the page loads and I change an attribute like length or width.

I did notice that my images/ajax-loader.gif file was missing. Per lhungils' mention of this: ""NetworkError: 403 Forbidden - http://www.framesforlife.com/images" I though perhaps this image missing might be the hangup problem. But once I uploaded the image for DPU the same slow page load times persist.

[lhungil]

Wow, 10,000+ queries! Feels a bit high... Do you have the Query Cache plugin for 1.3.9 installed? Any "cache" prepopulated by Simple SEO URLs (or do you have Ultimate URLs installed)? Any chance of logging the queries to a file (for one product page load - disable after)?

[nigelt74]

Umm anyone else getting these issues on that page

Invalid App Id: Must be a number or numeric string representing the application id. connect.facebook.net/en_US/all.js:56

FB.getLoginStatus() called before calling FB.init(). connect.facebook.net/en_US/all.js:56

Uncaught NotFoundError: Failed to execute 'removeChild' on 'Node': The node to be removed is not a child of this node. blk01-p-32:154

Failed to load resource: net::ERR_CACHE_MISS http://www.framesforlife.com/black-p...-11/blk01-p-32

Failed to load resource: net::ERR_CACHE_MISS https://www.facebook.com/plugins/lik...alse&width=150
wouldn't they have an effect?