mysqli Database

Question

what is the maximum number of table for mqysli database,is so efficient/possible to have more than 500 tables.

Answer 1

Generally servers have no limitation for number of tables. But operating systems may pose a limit on number of files.
Btw 500 is not a number which you will be worry about it.

Answer 2

There is no limitations of tables in databases. You can create any number of tables. In our company we have more than 700 tables and still working fine. It's depends on the space of the OS where you store your data because when you do transaction number of rows in your table increases but actually your databases server store data in your operating system. You can store your data in any Drive.