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
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
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
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