+ 1

mysqli Database

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

17th Jan 2020, 8:26 PM
Kelzbiggie
Kelzbiggie - avatar
2 odpowiedzi
+ 3
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.
17th Jan 2020, 8:55 PM
Qasem
+ 3
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.
18th Jan 2020, 7:19 AM
A͢J
A͢J - avatar