dark_spoon2004 Posted April 29, 2008 Share Posted April 29, 2008 Hi guys! i just want to ask if mySQL is that flexible. i'm currently doing an webbased system for my company and i'm still having doubts in using mysql in my db server side. the system will be used by 500 employees and each employee will be having a query of a maximum of 500 each.. can mysql manage this kind of load everyday.. please share me your thoughts guys.. thanks! Quote Link to comment Share on other sites More sharing options...
fenway Posted April 29, 2008 Share Posted April 29, 2008 "500 each" what? Load shouldn't be a problem. Quote Link to comment Share on other sites More sharing options...
Fearpig Posted April 29, 2008 Share Posted April 29, 2008 Not quite sure what you mean by 500 each but I would think mySQL would handle 500 users. It all really depends on the complexity of your queries as this is a big factor in determining the speed of the response. (I find mySQL a LOT slower at running hugely complex queries but then I have an SQL server to play with and they aren't cheap if you are paying!) Quote Link to comment Share on other sites More sharing options...
dark_spoon2004 Posted May 1, 2008 Author Share Posted May 1, 2008 Not quite sure what you mean by 500 each but I would think mySQL would handle 500 users. It all really depends on the complexity of your queries as this is a big factor in determining the speed of the response. (I find mySQL a LOT slower at running hugely complex queries but then I have an SQL server to play with and they aren't cheap if you are paying!) thanks for the reply.. what i mean with "500" is the employees will be entering data in the system simultaneously with a maximum of 500 everyday. We currently have more than 500 employees and each employees will be using the web base system simultaneously. It keeps me wondering if mySQL can handle such huge load of data. the queries are like adding names, time , addresses and etc.. thanks. Quote Link to comment Share on other sites More sharing options...
Fearpig Posted May 1, 2008 Share Posted May 1, 2008 ... 500 simultaneous users, all performing uploads! Not sure if mySQL would handle that very well as I run any larger sites on MSSQL and I just don't have any experience with high volume mySQL sites. - Sorry! :-\ Does anyone else know? Quote Link to comment Share on other sites More sharing options...
Fearpig Posted May 1, 2008 Share Posted May 1, 2008 Fenway wrote this sticky which might help.... http://www.phpfreaks.com/forums/index.php/topic,126096.0.html Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.