Maximum number or products OsCommerce will handle?

[ColoradoZ71]

If anybody has an idea of how many products OsCommerce will handle, please let me know.

 

Thanks

[davidinottawa]

If anybody has an idea of how many products OsCommerce will handle, please let me know.

 

Thanks

 

afaik it is limited by your db and your disk space.

However - I personally would not run MySQL with anything over say ........ 20 000 records ?

At some point you'd need to move to a commercial product.

[kayakbabe]

At some point you'd need to move to a commercial product.

 

I have to disagree wtih davidinottawa.

 

Mysql is used commercially by fortune 100 companies even.

 

If mysql and the server it is hosted on is configured properly it can handle hundreds of thousands of records.

 

I suggest that before spending bucks on a really exepensive and harder to modify product for your store.

 

You might think about moving to a dedicated server. The speed gains of not being on a shared box are profound. And you are going to be subjected to server overload created by other people who have badly coded websties. Plus you can have access to setting different error tracking and debugging levels so you can clean up your oscommerce code in order to make it run lean and mean.

 

A lot of the contributions are coded really sloppily and create way more load on the server than they need to. If you have a lot of those, you might need to go through the most accessed files and clean them up. I found so many contributions ran queries against mysql when it wasn't necessary, the data was already put into php arrays and accessible to the 'included' contributions. It was a factore of 200% or more speed gains when I did that on the product info screen alone!

 

I have three oscommerce stores that run against a single dedicated mysql server.

the mysql server does nothing except host the databases only. One of the stores itself is load balanced across 2 servers.

Yet they all use the same backend mysql server.

 

Mysql isn't the limiting factor at all.

[kayakbabe]

Two of my stores have only about 2000 products.

One of them has about 20,000 items.

 

I have heard of oscommerce store that have more. But not been involved in those.

 

I'm sure they clean up their php to get it as effiecient as possible.

 

And also analyze their mysql databases to make sure the correct indexes are placed on the tables.

Incorrect indexes can really slow down the queries.

[Guest]

afaik it is limited by your db and your disk space.

However - I personally would not run MySQL with anything over say ........ 20 000 records ?

At some point you'd need to move to a commercial product.

Actually you should move your store from a commercial product to oscommerce if you want to be successful.

[satish]

well any store with any number of products can be run on oscommerce.

 

 

 

Satish