Customers Also Purchased function SLOW

[imcrow]

I am having an issue on a couple of our more popular products in OSC. A couple of our top-selling items also cause the "customers also purchased" function to take 10 to 20 seconds to load. I have added an inded to the sql table.

 

Here is an example:

http://www.greenhousecatalog.com/topsy-turvey-p-181.html

 

When I disable the also purchased function, the page loads flawlessly.

 

Any suggestions?

 

TIA!

[boxtel]

I am having an issue on a couple of our more popular products in OSC. A couple of our top-selling items also cause the "customers also purchased" function to take 10 to 20 seconds to load. I have added an inded to the sql table.

 

Here is an example:

http://www.greenhousecatalog.com/topsy-turvey-p-181.html

 

When I disable the also purchased function, the page loads flawlessly.

 

Any suggestions?

 

TIA!

 

I personally use "ap-preselection" which basically runs the also purchased logic (actually even more extensive as osc only counts the products purchased in the very same order as also purchased, this one includes all products the same customer purchased ) on all products in a scheduled job daily and fills a runtime result table which simply links product A to product B as in for product A -> product B is also purchased.

 

Queries on that table are obviously much faster to access online.

[Guest]

Are you using caching? It seems to me that is the best solution. It refreshes often enough for most purposes, and keeps you from calling the database every time, which is what sounds like is the problem.

 

Matt

[boxtel]

Are you using caching? It seems to me that is the best solution. It refreshes often enough for most purposes, and keeps you from calling the database every time, which is what sounds like is the problem.

 

Matt

 

yes, caching will solve a lot of performance problems. I use it a lot out of mere necessity.

 

But still, someone has to create those cache files once in a while for every product and with 20-30 seconds they are not the lucky ones.

[Guest]

But still, someone has to create those cache files once in a while for every product and with 20-30 seconds they are not the lucky ones.

 

use the spiders.

if($spider_flag && //cache is old enough)

// run cache recreate

[jhsands]

use the spiders.

if($spider_flag && //cache is old enough)

// run cache recreate

 

Do you stick that in /catalog/index.php and I suppose you must turn the spider option in admin on?

[boxtel]

use the spiders.

if($spider_flag && //cache is old enough)

// run cache recreate

 

true, but it still remains a game of who gets to a non-cached or expired product page first.

if an individual page takes 20-30 seconds to load, solve that I would say.

[imcrow]

Are you using caching? It seems to me that is the best solution. It refreshes often enough for most purposes, and keeps you from calling the database every time, which is what sounds like is the problem.

 

Matt

 

Caching was not turned on. I enabled it, loaded the problematic pages, and it seems to have helped quite a bit. Thanks for the tip!

 

Brian

[Guest]

true, but it still remains a game of who gets to a non-cached or expired product page first.

if an individual page takes 20-30 seconds to load, solve that I would say.

Depends how the cache operates. I set it up for spiders to update, I know spiders visit say at least once a day, I setup the cache update to say 3 days. Now theoretically users would never have to go through the cache update because spiders are assigned for this task. Now if I update a product from the osc admin I could automatically update the cache for the products at the same time.

 

I am using some ideas from the cache contributions (I am not talking about the default cache) and most queries with static info (like product listings, categories etc) go through the cache first.

 

Unless it is critical to update the cache, (does the "also purchased" needs to be done immediately? I mean it could be done after a day or so by the spiders) there shouldn't be a problem.