Brown trousers time :~

Matt S Trout dbix-class at
Tue Oct 9 18:52:10 BST 2007

On Mon, Oct 08, 2007 at 10:50:24AM +0100, Jonathan Stowe wrote:
> It won't make any difference whatsoever - the same engine has to deal
> with the requests anyway. Separate databases just makes your design less
> rational and will add overhead at the language layer. Splitting the most
> used tables across separate disc spindles will certainly help, but MySQL
> never used to have a facility to do that (I'm sure it will be available
> in the very next version to the one available.)

Recent MySQLs let you have an InnoDB store file per table.

It's about the only feature added with version 5 that I've found useful.

      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director          
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?  

More information about the mailing list