HELP!!! - Store pages take minutes to load

[Guest]

Hi,

 

I have a serious problem that I need some help with. Some of my store pages are taking forever to load. Here are the symptoms I have diagnosed thus far:

 

- Upon creating a product the item works fine for a few page views

- After about 3 or 4 page views of the product, the page load time drastically increases

- My image sizes are not large. I have them optimized. Image/page size is not the problem

 

Here is a sample page that is taking too long to load:

 

https://stao.ca/scientia/product_info.php/c...products_id/146

 

I really need to resolve this problem.

 

If you have any questions please let me know.

[♥Monika in Germany]

disable search engine friendly URL in admin -> configuration -> mystore

[Guest]

Hi,

 

I just tried that and have not noticed a change yet. I will keep you posted.

 

This is my top priority right now and has 100% of my attention.

 

Thanks,

 

Andrew

[VectorSix]

The loads completely in < 2 seconds for me. It's actually one of the faster osC sites I have seen.

 

USA - GMT 19:04

 

V6 :thumbsup:

[♥Monika in Germany]

it may have to do with your SSL ... your whole shop is only available via SSL?

[Guest]

Hey all,

 

GOOD NEWS!

 

After changing the setting to false for the "search engine" thing and rebuilding all of the products things are running beautifully.

 

It appears that the problem was related to that setting. I also went and started rebuilding some of the database, but I stopped when things appeared to be working fine.

 

Thanks for your help!

 

I'll keep you posted if anything changes. I hope this works fine now.

 

Cheers,

 

Drew

[Guest]

I have also been making sure that there are no duplicate product models and that every product has an image. I read somewhere that this can also cause errors.

 

Just FYI

 

Drew

[VectorSix]

I tried the sample page that you talked about, but you must have deleted the item. There are two people trying to help, but help us help you, ok? What about Monika's question that she asked? Post another product and leave it so we can check it out....

 

V6

[driftwood]

Hey all,

 

GOOD NEWS!

 

After changing the setting to false for the "search engine" thing and rebuilding all of the products things are running beautifully.

 

It appears that the problem was related to that setting. I also went and started rebuilding some of the database, but I stopped when things appeared to be working fine.

 

Thanks for your help!

 

I'll keep you posted if anything changes. I hope this works fine now.

 

Cheers,

 

Drew

 

It might be a silly question but do you host any advertising ?

 

Pulling in banners can really fug-up your access speeds.

 

Drifter.

[jpweber]

Yeah, I try to load the page https://stao.ca/scientia/product_info.php?m...products_id=148 and it's been about a minute and it's still loading. It took about 80 or so seconds and finally loaded. Other product pages load fine. The weird thing is that now I go back to the same product, clicking it from my shopping cart (I added it), and it's not there -- 'product not found'. So that link may not even be good now.

 

Why is the products page SSL'd with the http://? Only pages that require data input should be necessarily protected by SSL. Did you adjust your scientia/includes/configure.php file incorrectly? It should look something like this:

define('HTTP_SERVER', 'http://stao.ca');

define('HTTPS_SERVER', 'https://stao.ca');

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', '.stao.ca');

define('HTTPS_COOKIE_DOMAIN', '.stao.ca');

 

That's it -- only one has "https" on it (the 2nd one). If you're on a shared server with a host, near the bottom of your configure.php file should be something like tihs:

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql');

 

1) Set your admin --> configuration ---> Use Cache to false.

2) Make sure your admin --> configuation ---> maximum values aren't 'too' maximum.

3) In your admin --> configuration --> Sessions, I would have this:

Session Directory /tmp/

Force Cookie Use - false

Check SSL session ID - false

Check User Agent - false

Check IP address - false

Prevent Spider Sessions - true

Recreate Session - true.

 

Just a few suggestions. Good luck.

[Guest]

I'm back to slow products again this morning. Again it is only specific products that seems to be affected.

 

Here is a sample again: sample

 

I have changed all of the setting except the secure portion. I want the entire site encrypted by ssl. This should not cause any problems. I have other stores running 100% encryption and it does not affect their performance.

 

Any new ideas? Could it be a bad contribution?

[Guest]

Here is another piece of the puzzle. After rebuilding all of the products yesterday, the only product pages that load slowly today are the ones that have been recently ordered.

 

It seems that the more an item is ordered, the slower it's page runs.

 

Any thoughts?

[♥Monika in Germany]

comment out the also purchased box in product_info.php

[jpweber]

I have also purchased as well, so I'm not 100% sure that that is the problem.

 

And yep -- page took me about a minute or so to load; I would have x'd it out by that time, if I was an end-user. So this definitely has to be addressed, and I'm more than willing to help my neighbor in Dresden, however ....

 

(a) Why do you want your entire site SSL'd? Doesn't really make sense; it's only needed for data encryption where the end-user requires some form of data input (create account, checkout, etc., etc.).

 

It could be a bad contribution. Can you please list the contributions you've installed?

 

Make sure admin --> configuration --> switch to default language currency is set to 'false'.

 

Sounds to me like your database queries are slowing things down, for some reason.

 

My last guess is that if this only happens the first time you load the page, which you said might be the case, because your hosting site has not set up your server for a faster analysis of the translation of the IP Address ... This is for the Who's Online in the admin.

[♥Monika in Germany]

I insist you comment out that box first before you try all other solutions ... ok?

[Guest]

Eureka!

 

I have finally found one of the main problems. After going through logs of errors it turns out that a contribution I installed a while ago is causing massive delays.

 

If you are running an "upgraded" version of the: Also_purchased_products feature then restore your original file right away.

 

The problems appear to have completely disappeared. Even the slow moving products are now back to normal.

 

Like I said before, I will keep you posted if anything changes.

 

Thanks for everyone who has commented. I hope that if anyone else runs into this problem they will find this posting useful.

 

Cheers,

 

Drew :D

[edtiger]

Thanks for the great tips. This forum helped me speed up a site I was having troubles with as well.