MySQL retrieval speed for many connection attempts at the same time
I am not so experienced with databases and wonder about their speed when 100-1.000 people try to connect and pull info from the database at the same time?
What happens? Does it explode?
There are 500 unique ID and each row has 10 variables that need to be pulled.
If 1.000 people try to connect to the database at the same time and try to pull those 10variables. Will the fetching be really slow and when does it crash?
I have not a clue about the speed of retrieving from a db. I have read about storage of million of records that goes really fast for a low amount of users. Then I have also read something about max 500 connections to a db at a given time.
I guess the primary question is how many users can connect to such a database at a given time with the db being able to send back the info in less than a second?
Then how long time does it take to search 500 random unique ID?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.