Oscommerce does work with 10.000 articles?

[giuli8]

Oscommerce does work fine with 10.000 articles?

Thank in advance

[Bryce F]

Oscommerce does work fine with 10.000 articles?

Thank in advance

 

I assume you mean "10000 different products". The easy answer is no - it's query engine is too slow because of inefficient database joins (products and products_descriptions is especially slow).

 

The hard answer is: it's absolutely capable if you do some hacking. I completely rewrote the query engine for my osC store and consolidated products and products_descriptions into 1 table. I have about 35000 different products and it works lightning fast.

[Xpajun]

 

The hard answer is: it's absolutely capable if you do some hacking. I completely rewrote the query engine for my osC store and consolidated products and products_descriptions into 1 table. I have about 35000 different products and it works lightning fast.

 

 

So the answer is yes then :-" :-"

[Hotclutch]

There are osCommerce stores around with a million plus products, but I assume they have some database optimization in place.

[Bryce F]

So the answer is yes then :-" :-"

 

The answer is yes, but doing this is non-standard. You will have to customize your version of osC to do this. Unfortunately, there is no set way to do this and will vary case-by-case, depending on what your specific needs were. In my case, I combined 2 tables ("products" and "products_description") and cleaned up every single query to reflect this change. I had to make a lot of other little changes too. Most people won't be able to help you with this because, as I said earlier, there is no set way to do this.

 

If you're comfortable with PHP and MySQL, it's easily doable. If you're not, osC might not be the best choice for a 10000-product store.