Brown trousers time :~
Matt S Trout
dbix-class at trout.me.uk
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 http://www.shadowcat.co.uk/catalyst/
Shadowcat Systems Ltd. Want a managed development or deployment platform?
More information about the london.pm