johnsmith153 Posted April 2, 2009 Share Posted April 2, 2009 I know I will get a lot of "depends on size of fields etc.", but I would appreciate an idea as to expected response times for a mysql database. I have a script that checks a table for all logins and returns info. (basic table with about 10 fields - each with maximum 50 characters) If a record is retuned, it sets the PHP sessions and is complete. The table DOES have perfectly tunes indexes set up. At the moment, the entire PHP script runs perfectly and executes in about maximum 1 second. - finalising with the successful login. However, that is because there is 1 login record! What about if the login table holds 1 million records - searching this will obviosuly impact on the one user who now has to wait for the dbase to search 1 million rather than 1 record. If it takes 1 second now, what is the worse that 1 million could take? A rough estimate is fine - i.e. are we talking a few seconds - or are we taking 15-20 seconds etc.!! My server is an excellent cloud server that can cope with any network load - so number of users / network load is not a problem. If anyone has experience what you can expect from a mysql running on a good server - ie answer might be expect 1 second per 10-50,000 records etc. - that would be great. Quote Link to comment https://forums.phpfreaks.com/topic/152268-quick-question-mysql-response-times/ Share on other sites More sharing options...
JonnoTheDev Posted April 2, 2009 Share Posted April 2, 2009 Can you post the query Quote Link to comment https://forums.phpfreaks.com/topic/152268-quick-question-mysql-response-times/#findComment-799609 Share on other sites More sharing options...
xylex Posted April 2, 2009 Share Posted April 2, 2009 You're asking for an abstract run time on an abstract query inside an abstract script running on an abstract cloud system? Any reason you can't just add the million records and try it out? It'll only take a few minutes. Quote Link to comment https://forums.phpfreaks.com/topic/152268-quick-question-mysql-response-times/#findComment-799613 Share on other sites More sharing options...
Mark Baker Posted April 2, 2009 Share Posted April 2, 2009 If The table DOES have perfectly tunes indexes set up then this shouldn't be a significant issue, unless you really expect millions of concurrent logins.... in which case it's the data transfer between the database and PHP that will be a problem, not the database searching Quote Link to comment https://forums.phpfreaks.com/topic/152268-quick-question-mysql-response-times/#findComment-799631 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.