Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How many users can osc handle at once


altenter

Recommended Posts

Posted

Hello,

Can OSCommerce MS2 handle around 10000 products with thousands of online users at once?

Do i need to make any special adjustments to the default setup for this to work fluently?

Are there any other limitations other than hardware?

I will be using linux hosting with apache version 1.3.34, MySQL version 4.1.14-standard and PHP version 4.4.1

Thanks for your replies.

Posted

This is a question with no definite answer.

 

MySQL can easily handle the database size corresponding to thousands of users and 10000 products, but it does have to be tuned correctly. OSC sends some intensive queries. An out-of-the-box type installation of PHP and MySQL will probably start to show performance problems at that level.

 

Also, you would want to take some steps to relieve the query load on the database, such as page caching and turning off things like category counts. And of course, faster hardware helps. PHP doesn't usually need the fastest thing out there, but MySQL databases with high load do.

Contributions

 

Discount Coupon Codes

Donations

Posted

I agree that there isn't anything software wise that would prevent that level of operation.

 

Hardware wise, you would benefit from putting the database on its own high performance server. Then put the site on a server with apache optimized for high concurrent connections and php with an accelerator.

Rule #1: Without exception, backup your database and files before making any changes to your files or database.

Rule #2: Make sure there are no exceptions to Rule #1.

Posted

Thank you KG and Mike for your replies. I am relieved i can use oscommerce for this project :)

Could you reccomend a link with more specifications on howto setup page cache correctly and on steps to relieve the query load on the database, or any other usefull piece of advice?

Thanks.

....i wish ms3 was stable enough...

Posted

This one might be a good starting point (be prepared for a long read, 328 replies):

 

A Store Speed Optimization in Progress, Step by step from a vanilla install!

 

For a shorter read there is this one:

 

Awesome speed improvement

 

As for server side optimizations, Google things like:

  • "optimizing mySQL"
  • "optimizing Apache"
  • "Apache max connections"
  • "php accelerator"
  • mmcache
  • "Zend Optimizer"

Rule #1: Without exception, backup your database and files before making any changes to your files or database.

Rule #2: Make sure there are no exceptions to Rule #1.

Archived

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

×
×
  • Create New...