Pages loading very slowly

nigelt74:

Umm anyone else getting these issues on that page ... wouldn't they have an effect?
Yes they have an effect. However when you disable javascript (in the browser) all those errors go away (and the time spent just to read the initial HTML file w/o javascript is still 6-12 seconds).

Now the 10000+ database queries accounting for 6-11 seconds of the load time would be my focus. Not saying the javascript issues should not also be addressed, just that the larger bottleneck appears to be time spent querying the database.

NOTE: During traditionally non-peak US hours, the database query time (at least what I was seeing) dropped to 2-4 seconds... Which indicates during peak US hours the database server may be a little overloaded... But again, the core question is why so many database queries (even in Ajeh's over the top example only about 3824 were required)?

RixStix:

Looking at the product attributes (mat color),

Is the "discounted" checkbox showing a red X or fuschia color?

Assuming that the mat attribute does not affect price AND the attribute is colored, try deselecting the discount attribute so that it shows a RedX.
.

that is a lot of discounts to calculate on each page update IF the attribute does not affect pricing.

uncheck those fuschia boxes for attributes that do not affect pricing & see if that makes a difference.

It sure made a huge difference for me.... unless we are talking apples to oranges instead of apples to apples.

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)?

I do not have Query Cache plugin installed. But I do have simple SEO URLs. Here are all the modules I have:

1. Simple SEO URL v3.5.8
2. Backup ZC v.1.0.7
3. RSS Feed v 2.1.4
4. Newsletter Subscribe 2.2.2
5. Facebook Twitter Module 1.0
6. Auto Tweet and Auto Facebook Modules
7. Quick Status Updates
8. Quick Updates v.2.0.5
9. Additional Product Images v.1.0
10. Dynamic Price Updater 2.01
11. FedEx Web Services v1.1.2
12. PO Box Ban
13. Flexible Attributes v1.0
14. Multi Cross Sell v1.02
15. Captcha Number Subject Combo All In One v1.3.8
16. Image Manager v.1.7
17. Edit Orders v3.03
18. Quickbooks Sync Web Service v.2.02
19. Encrypted Master Password
20. Admin Login As Customer 2.2
21. Whos Online
22. Testimonial Manager
23. GV Admin Edit

As far as "Any "cache" prepopulated by Simple SEO URLs: How would I find this out? I do have an area in my admin panel (Extras> Simple SEO URL Manager) that has a lot of reset and manage aliases options. I have never reset. Should I reset all these? My next questions is how do I log the queries to a file? Logging> Database queries? I can enable for a product page load, but I don't know where to go for this.

nigelt74: I think I did have the Facebook, Twitter module working at one time. Now when I create a new product I get a red error:

[IMG]https://www.framesforlife.com/4mypanel/images/icons/error.gif[/IMG] Facebook Error: Error validating access token: The session has been invalidated because the user has changed the password.
 [IMG]https://www.framesforlife.com/4mypanel/images/icons/error.gif[/IMG] Twitter could not be updated: : To paste the code into twitter yourself use: 
New product available: Test! Check it out now at http://bitly.com/1vaU33z