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