Hey all - I've got a site with several scripts / programs installed that each have their own DB. The site is getting to be kind of slow, and I think (correct me if I'm wrong) that part of the issue might be that for each user, the server ends up having to open multiple database connections.
For example - I have a database for phpbb and wordpress. I also have a db for some custom site stuff.
Does it make sense to put all the tables into one 'master' database? That way, in theory, a user is just opening up one call to the db.
I suppose its not so much a single database as it is a single db user accessing the db. Where as right now for each db I have a different user setup...So one person visits, if I understand correctly, this would spawn 5 sessions hitting mysql?