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 [EMAIL PROTECTED] to access it. -Alex > -----Ursprüngliche Nachricht----- > Von: Evaldas Imbrasas [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 04. April 2007 00:31 > An: [email protected] > 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- > [EMAIL PROTECTED]/ *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* 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. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* _______________________________________________ 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/[email protected]/
