1 DB w/ many tables VS Many DBs w/ few tables

[darmonkey]

Hello,

Which of the following would yield the best performance:

Option 1: 1 DB with roughly 30000 tables
Option 2: 1000 DBs with roughly 30 tables each

Additional Information:
- Each table will be relatively small (no more than a few hundred records up to a few thousand)
- There will be a lot of SELECT and INSERT statements ran.

Follow up question: What engine should be used: InnoDB or MyISAM?

If there is additional information that would be needed to make a good recommendation, please let me know and I will post it.

Thanks!



Edited 2 time(s). Last edit at 12/27/2005 02:30PM by darmonkey.