[Dbix-class] Moving table out of database

[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 class and have =

> two $schema objects for the two connections?

Hey Bill. If you grok numerous responses I've given over the years this =

depends on your database backend and your concept of schema connection. =

For MySQL, MSSQL and Oracle : as long as you have your DBIC schema =

namespace set up right you can transverse 'database/schema' all on a =

single connection. For PostgreSQL this is a no go. <And again disclaimer =

if I have not gone through the docs correctly :) >

In the former case, the best option is via SQL::Translator aka Fairy, to =

genere
>
> I'm assuming any place that table is used in a join will need to be =

> rewritten.
>
> -- =

> Bill Moseley
> moseley at hank.org <mailto:moseley at hank.org>
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.=
co.uk



---
This email is free from viruses and malware because avast! Antivirus protec=
tion is active.
http://www.avast.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20131211/524=
a4c85/attachment.htm