Msg#: 4268571 posted 6:55 pm on Feb 17, 2011 (gmt 0)
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.
Msg#: 4268571 posted 5:50 pm on Feb 18, 2011 (gmt 0)
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?