would creating multiple tables instead of single be better in a lot of connections
If I'm creating a database which would be used by lot of differe开发者_如何转开发nt users at the same time constantly inserting and retrieving rows, would multiple tables be better? If not speed-wise, would it be better deadlock-wise?
For a better management of concurrent queries...
use the InnoDB engine instead of MyISAM
if you really have a lot of connections, it could be wise to use MySQL Cluster
精彩评论