mySQL: How many rows in a table before performance is affected?

Posted by Industrial on Stack Overflow See other posts from Stack Overflow or by Industrial
Published on 2010-06-09T17:10:05Z Indexed on 2010/06/09 17:12 UTC
Read the original article Hit count: 139

Filed under:
|
|

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!

© Stack Overflow or respective owner

Related posts about mysql

Related posts about Performance