Thursday, 22 August 2013

Sideeffect of large number of MySQL tables

Sideeffect of large number of MySQL tables

Is it OK to keep 10000+ tables in a MySQL database? I'm making a
messaging/chat script, so I'm thinking about partitioning data's over
several tables as it will be a huge amount of data after some days. IS IT
OK? Or it has some effect? Well, as a table can hold millions of rows so I
was thinking maybe a database can hold large number of tables too
I'm a newbie in MySQL, please help

No comments:

Post a Comment