I have a project in PHP and MySQL which requires quite a large number of tables, there are around 40 tables. Right now, I have them all in one database.
However, I'm wondering whether that is too much for one database? Or should I split up some of my tables into another database? (My host does provide support for multiple MySQL databases)
Thanks in advance.
40 tables really does not seem like that much.
Backup and recovery could be an issue if you split up the tables into multiple databases. Unless you can assure that both databases are backed up at exactly the same time, they may get out of sync. if you ever have to restore one or the other.