Recent Posts
Sponsors
 |
MySQL 1 Million Rows Golden ruleDawn Rossi, 10-10-2008 |
According to MySQL documentation there are no software limits on the number of records per table. Some users report using MySQL with 50 million records and more.
Here in SoftwareProjects we found it's okay to use MySQL "archive type" tables with tens of millions of records, but for all active tables where you're constantly inserting, updating, deleting and querying the table -
Do NOT load up more than 1 million rows into a MySQL table.
We measured a considerable performance degradation whenever there are more than 1 million rows in an active (busy) table.
If you need more than 1 million rows, look into: partitioning, sharding or a purge script that will move unused rows to an archive type table.
Here in SoftwareProjects we found it's okay to use MySQL "archive type" tables with tens of millions of records, but for all active tables where you're constantly inserting, updating, deleting and querying the table -
Do NOT load up more than 1 million rows into a MySQL table.
We measured a considerable performance degradation whenever there are more than 1 million rows in an active (busy) table.
If you need more than 1 million rows, look into: partitioning, sharding or a purge script that will move unused rows to an archive type table.
|
|
Subscribe Now to receive new posts via Email as soon as they come out.
Comments
Post your comments
