Brown trousers time :~

[Matt S Trout]

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                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/