I've been searching for a hosting service, and some hosting offer unlimited databases while other offers 1, 2, or a few. My current host offers only 1 database, and I have installed all of my programs, forums, photo gallergy, etc, into one large database.
Does it affect the query execution time if there are so many tables in one database?
Allen Burnett StormHosts[email protected] Professional MS ASP, .Net, MS SQL 2000/2005 and Reseller Hosting Since 2001 Clustered servers @ Equinix Helm/cPanel/WHM/VPS/colo/Dedicated/MailFoundry anti-spam/Server Mgmt
Not really, as you would normally specify the table needed when you connect, it's not like MySQL is searching through the entire database for each query, but it depends really how many tables you have, some larger scripts may show some difference.
The main advantage to seperate databases is obviously things are easier to manage and there's less risk of overwriting anything important by mistake.
Thanks for the quick reply. Right now I have exactly 87 tables, and the number might go up in the future. Is it too many table for 1 database?
The reason I was asking about this is because I need to create a website for my church which will be mainly using database for almost everything. The hosting company, lunarpages, that i have for my own website offers only 1 one database, and I have submitted a quote to get a better deal for the church account.
btw, rather than planning to move everything just for this reason, there's no harm in asking your current host if they would add one or two databases, if they value your business it wouldn't be a problem for them.