atomicnuke
02-03-2006, 09:33 AM
I was just wondering if someone could give me some input. As a site grows is it better to have multpile DB's with specific tables or all tables in one DB? I've heard that the most straining thing is opening and closing DB connections. But would it be more taxing if one DB has several tables, about 10, with several 100 records in each table, maybe more as the site grows. Right now I have three DB's with a couple tables in each, with expected growth from users. Since tables are sometimes in other DB's but accessed by the same page, I have to close the connection, open a new one, then sometimes close that, to open another. I've heard hosting companies frown upon this for running up server usage, so was just wondering if anyone has input on the matter? I have main content that pulls from one DB and side content that pulls from another, but since they are on the same page, i have to close/open connections.