David Blomstrom said: > I discovered by accident that I can link any website > on my reseller account to one database. That would be > far more convenient than working with six separate > databases, and it would also cut down on file size > overall, since there are certain tables that I share > between websites. > > But my host warned me that a big database could > increase query time and make it harder to update. I > want to understand exactly how this works. The problem would be large tables rather than large database. Traversing a table is what costs time.
There would be a slight increase in the Operating System finding the files associated with each table, but this is a factor only with very large numbers of tables not 100. This all assumes MyISAM table type. I don't know about the others since they do share a single file. > Suppose I have two database tables and one website > that's linked to both those tables. Suppose it takes > one second to query those tables. > > Now if I add 100 tables, but my website still queries > just two of them, will a query still take one second? > Or will those additional tables slow things down, even > though my website doesn't even make any reference to > them? > > And will those extra websites make it take > increasingly longer to add additional tables or modify > existing tables? > > I would think my local database ought to be a good > guide. I have over 100 tables in the same database on > my computer, and things seem to work just fine. Of > course, I realize things take longer online. My > webpages do run a little slow, but I think that's > because of some sloppiness in designing my database > tables; that's something I'll just have to refine as I > learn more about MySQL. > > Thanks. > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > http://smallbusiness.yahoo.com/resources/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
