MySQL Forums
Forum List  »  Performance

Lots of tables One db vs. Many dbs, less tables. ONE mysql server
Posted by: Erin ONeill
Date: October 26, 2005 01:21PM

Hey all -
Sorry I've been absent from the forum (new job!). My new developers have a strong Oracle background and some things are a bit difficult to translate into MySQL. Database instance is one of them.

In MySQL I've found it easy to have a number of databases, each with their own data (usually many identical table names). I can even have a global db that they can do joins on.

But I need to think about performance & optimization and scaling up. Is it better to use a prefix on a table name and have lots of tables in a database or put them into separate databases?

Experts?

erin
ps. Jay, I got your new book & looked this up there but couldn't find any discussion around this issue??

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.