Re: [Dbix-class] Moving table out of database

2013-12-27 Thread Darren Duncan
Actually, PostgreSQL can do the traversal as well, recent versions at least. PostgreSQL versions 9.3+ support federated databases for both reading and writing, and versions 9.1 thru 9.2.x support federations for reading. So you can, at the database level, make it look like your moved table sti

Re: [Dbix-class] Moving table out of database

2013-12-10 Thread neil.lunn
On 11/12/2013 5:00 AM, Bill Moseley wrote: One of our tables has become very large in our database and we are looking at moving it into a separate, partitioned database Crap. mail fail. Suffice to say, DDL diffs via SQL translator will work in the former case. But YMMV on performance hit, down

Re: [Dbix-class] Moving table out of database

2013-12-10 Thread neil.lunn
On 11/12/2013 5:00 AM, Bill Moseley wrote: One of our tables has become very large in our database and we are looking at moving it into a separate, partitioned database. Is there anything more "clever" we can do with DBIC to abstract this out other than pull this result class out into a new cl

[Dbix-class] Moving table out of database

2013-12-10 Thread Bill Moseley
One of our tables has become very large in our database and we are looking at moving it into a separate, partitioned database. Is there anything more "clever" we can do with DBIC to abstract this out other than pull this result class out into a new class and have two $schema objects for the two co