Hi Peter, You can probably safely have at least 1000-2000 tables in a single database.
Hope that helps. Matt ----- Original Message ----- From: "peter" Sent: Friday, November 28, 2003 12:03 PM Subject: newbie question > Hi > I am a webdesigner/hosting reseller > my question is this: > > I am hosting various different CMS attached to mysql databases and hope > to host more in the future > How many different tables can I safely store in the same database? > I am currently storing tables from three different CMS on the same > database with different prefix's > Can I keep adding more? is there a significant performance issue with > multiple sites using the same database? > > I'm not really that up to speed on mysql or databases in general > so...... > > any thoughts? > > thanks > > Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]