Hey Guys, I was wondering what's the realistic maximum size of an MySQL database before it takes an unworkable time to query? Say each record had 3 fields of 32 characters maximum each? How many records would I be able to get before it coughed to a halt? Love to hear opinions, Rory
How about to create a script that fills such a table and then try different queries to see if it crashes?
I do not thing it can be a limit. I ran a 2GB SQL Database, and it was working ok, it just depends on how you create your indexes.
You can easily create 1 master - multiple slaves cluster with MySQL databases. Inserting the data in the master and querying the slaves give you really good performance. But as DanielRosca said ... the performance of the database depends on the database design first...