A very large store

[kenkja]

I have what I percieve to be a very large store, with 49000 products in 1600 categories.

 

Originally my intention was only to have 4 or 5 parent categories, 1 of which would hold around 70% of the products, however the more products I added the slower the load speed became, both in the store and in the admin.

 

So I ended up comprimising on what I thought was going to be a vary simple category box and it now has 50 parent categories and still needs to grow.

 

So after giving it some thought and help on the chat line, I know that I probably should recode the categories box to only show the parent categories - there is an add on for this but it is v2.2 so will need a bit of conversion - but a good place to start

 

However even when this is done, the current category tree has been changed back to how I originally wanted, onclicking the parent category which holds 70% of the products, osc will still try to populate all of these for the next page, i think - because of the // check to see if there are deeper categories within the current category on about line 50 of index.php.

 

So lets say that in this category, there are 2 children, who each have 5 children and each of them as has 10 and they have say 30 where the products are ultimately held.

 

In a complete roll reversal of how osc is working ( i think) on clicking the parent, if the search only found the next level down, the 2 children and did not search right to the bottom, it would obviously load quickly, Ultimately after a number of clicks throung the category structure, you get to the bottom and then load the products.

 

Am I right in thinking this is turrning the whole search thing on its head ?

 

Ken

[kenkja]

Lets say this could be achieved, do you think users would become bored of clicking though all the pages needed to finally get to see the product listing ?

 

Ken

[Guest]

Lets say this could be achieved, do you think users would become bored of clicking though all the pages needed to finally get to see the product listing ?

 

Ken

 

I was thinking maybe you can use ajax and jquery. It must lower the load time.

 

Here is an example:

http://techlister.com/jquery/ajax-pagination-using-php-and-mysql-jquery/638/

[burt]

Backporting the 2.4 category_tree class and categories box might prove helpful.

[Jack_mcs]

@@kenkja I think that with that many categories and products, you will need to go to a filter system like Amazon.

[RMD27]

Personally i dumped the category box and hardcoded my own. Problem solved.

[Guest]

Personally i dumped the category box and hardcoded my own. Problem solved.

 

But in a few words can you tell us what did to solve the problem? I mean the concept of the idea.

[RMD27]

But in a few words can you tell us what did to solve the problem? I mean the concept of the idea.

 

Hi, sorry for the slow reply.

 

The standard categories box is a major drain on resources, it makes the site slow. I created a new info box and hard coded in the links that were in the Categories box so there are no queries.

 

If you don't change your main categories a lot this solution, in my opinion, is the easiest thing to do if you want to speed up the speed of your site while still have a box that lists your categories.

[discxpress]

@@kenkja

 

Did you ever get a solution to your categories issue? If so, please share

[tonylee5566]

@@kenkja

 

Did you ever get a solution to your categories issue? If so, please share

Please share :)

[♥14steve14]

See post #8 to see the answer

[♥kymation]

Alternate answer: Turn on the cache in your Admin panel. The categories box will then be stored in a file, eliminating all database queries for future requests. You will have to clear the cache manually every time you make changes to the categories.

 

Regards

Jim

[ozEworks]

Also make sure you turn off the category product count function as it can slow things down more than anything else.

[kenkja]

Hi All, sorry I didn't reply to @@tonylee5566 & @@discxpress, sooner but haven't been on the forum in ages.

 

Simple answer no, I never did solve it, however persuaded the boss to go from a shared server to VPS, which worked quite well for a while, then the site suddenly slowed down and eventually stopped altogether.

 

Having checked the cPanel error log, the difficulty seemed to be with my SEO Urls 5 install, I guess I must have done something wrong but not sure what, so disabled SEO in the admin section. That was about 6 weeks ago and its been, well not lightening fast, but very much quicker