Affiliatenichescript.com forums

[twitch]

Ok so the site slows down when there are a lot of categories added you can see this at http://www.2buyonlinenow.com is there anything we can do about this? right now im at about 7 second load times and I noticed the times get worse the more I added. Hope this helps you out you have a great script here. I hope this takes off for you. as long as the speed can be worked on this will be by far the best amazon affiliate script out there.

the other site this is running on is http://www.buyaipad.info and it loads pretty fast. but only has a few categories.

[twitch]

So after finishing up the store the site is almost unvisitable http://www.2buyonlinenow.com takes sometimes 15-20 seconds to load. I hope we can get a resolution to this or I'll be sad.

[admin]

Hi,

I think I may have discovered the cause. It's quite embarasing... but basically if your site had 1000 categories it would execute the following SQL statement 1000 times!!!

Code: Select all

SELECT * FROM ans_categories WHERE display = 1 ORDER BY page_order, node_name

I have updated this so now it will do what it is supposed to do which is to only execute it once, this has so far proved better results and would definitely explain why your site gets slower the more categories you add!

[admin]

Hi,

Just to add to what I previously applied, I have now enabled database caching for category calls.

In 1.1, when you load a page all queries related to category data are cached for 5 minutes. When you create,delete,sort or edit a category the cache will be reset.

[twitch]

Awesome glad you were able to tell what was going on. cant wait for 1.1 to drop. Is there a way so we can make the cache time maybe a few hours or so or even adjustable?

[admin]

Yes, that would be better.

I'll make it adjustable and default it to 10 mins.

[twitch]

You are the man.