mySQL: How many rows in a table before performance is affected?
- by Industrial
Hi everybody,
Is there a "known limit" for columns & rows in a mySQL table that when passed, it can be safe to say that performance is severely affected?
I've think that I had heard that there is a "golden number" that you really dont want to exceed in either columns or rows in a table. - Or is it all about the size of the index and available RAM + CPU on the server?
Thanks!