medisave Posted March 26, 2003 Share Posted March 26, 2003 Hello, All is going well with OSC - we are having lots of orders and lots of customers registering. We have a virtual dedicated server with root access (10 companies on one highspec server) Everything is fine at the moment and Im Happy. However looking to the future how many accounts / order history etc etc can oscommerce MySQL have before I would start to notice a slow down?? At say 25000 registered accounts will things be alot slower getting data in and out of the database? or say 100000? Same with order history etc. I also see in the MYSQL PHPMyadmin that there are options to optimize tabe and create table indexes - is this something I need to concern myself with ? anyone else apply these to their OSC Database ? Cheers, Graham www.medisave.co.uk Graham Wright ________________ Link to comment Share on other sites More sharing options...
mattice Posted March 27, 2003 Share Posted March 27, 2003 I applied indices to the db (there is a contribution that tells which to place where) and immediately noticed serious speed improvements on the store. As for customers / history etc.. only time will tell, there is no specific answer to that as it is highly depending on the traffic on your site and the nine other ones on the server. But a solution to seriously speed things up at that point in time is to move mysql to a seperate dedicated server (nothing else there, just mysql) Regards, Mattice "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.