AW: [Dbix-class] Data partitioning and DBIC

[Hartmaier Alexander]

Hi!

I can only speak for Oracle where partitioning means to split up a table into multiple tablespaces by one or more field value(s).
I use it to partition historical data tables by datetime and have a partition for every month.
This way you can delete old data without an sql statement and without stressing the db server.
You can also limit a select statement to some partitions instead of the whole table.

If you want to access tables in a different database you can create a database link and use schemaname.tablename at dblinkname to access it.

-Alex


> -----Ursprüngliche Nachricht-----
> Von: Evaldas Imbrasas [mailto:evaldas at imbrasas.com]
> Gesendet: Mittwoch, 04. April 2007 00:31
> An: dbix-class at lists.rawmode.org
> Betreff: [Dbix-class] Data partitioning and DBIC
> 
> Hi there,
> 
> I'm looking for tips to implement the data partitioning with
> DBIx::Class. Is there a standard way in DBIC to say that a few tables
> from the initial database schema are now moved to a different
> database, but still maintain the relationships between the tables now
> living in different databases?
> 
> Thanks.
> --
> -----------------------------------------------------
> Evaldas Imbrasas
> http://www.imbrasas.com
> 
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive: http://www.mail-archive.com/dbix-
> class at lists.rawmode.org/

*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH   Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*