Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help making a HUGE store


Guest

Recommended Posts

Posted

I am looking to setup a HUGE store of over 600,000 items

 

every item has a unique name

every item is the same price

every item has NO picture

 

When I have them all in one database the site is a hit or a miss whether it loads or not......

 

Would it work if I split it into 2 seperate shops (Shop 1 - items 0-300,000)

(Shop 2 - items 300,001-600,000)

 

Cheers for any help/advice

 

Michael

Posted

600k items is large, but not ooutside the scope of osCommerce.

One of my old clients has millions of items in a setup similar to yours - no images.

I coded it to have the image created for each product on the fly, taken from a standard background onto which text is placed.

 

What you need to do is strip osCommerce of everything that is un-needed.

Then optimise the SQL queries used (tax is one that is a biggy).

Then optimise your server to handle it.

 

I'm hoping that you are not attempting this on a shared webhost and that you have your own webserver specifically for this.

Posted

600k items is large, but not ooutside the scope of osCommerce.

One of my old clients has millions of items in a setup similar to yours - no images.

I coded it to have the image created for each product on the fly, taken from a standard background onto which text is placed.

 

What you need to do is strip osCommerce of everything that is un-needed.

Then optimise the SQL queries used (tax is one that is a biggy).

Then optimise your server to handle it.

 

I'm hoping that you are not attempting this on a shared webhost and that you have your own webserver specifically for this.

 

 

Cheers for the info.....I'm on shared webhosting unfortunately .... I didn't really think I'd have to go down the dedicated route for

my little project.

 

but I will do a search on optimising SQL queries

Posted

Splitting the shop shouldn't be necessary but a lot of attention will have to be applied to the queries, caching, avoidance of complex joins and table scans.

 

I imagine that split page results would be a bottleneck.

 

You don't mention the number of categories.

 

You replied while I was posting.

 

I doubt there is any chance at all of running a shop of this size on shared hosting.

Archived

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

×
×
  • Create New...