Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

A very large store


kenkja

Recommended Posts

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

Os-commerce v2.3.3

Security Pro v11

Site Monitor

IP Trap

htaccess Protection

Bad Behaviour Block

Year Make Model

Document Manager

X Sell

Star Product

Modular Front Page

Modular Header Tags

Link to comment
Share on other sites

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

Os-commerce v2.3.3

Security Pro v11

Site Monitor

IP Trap

htaccess Protection

Bad Behaviour Block

Year Make Model

Document Manager

X Sell

Star Product

Modular Front Page

Modular Header Tags

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 3 weeks later...

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.

Link to comment
Share on other sites

  • 2 months later...

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

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

  • 1 month later...

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

Os-commerce v2.3.3

Security Pro v11

Site Monitor

IP Trap

htaccess Protection

Bad Behaviour Block

Year Make Model

Document Manager

X Sell

Star Product

Modular Front Page

Modular Header Tags

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...