altenter Posted March 9, 2006 Posted March 9, 2006 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.
kgt Posted March 9, 2006 Posted March 9, 2006 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
GraphicsGuy Posted March 9, 2006 Posted March 9, 2006 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.
altenter Posted March 9, 2006 Author Posted March 9, 2006 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...
GraphicsGuy Posted March 9, 2006 Posted March 9, 2006 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.
altenter Posted March 9, 2006 Author Posted March 9, 2006 Thanks for the links, i better start reading.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.