XP is just a number | |
PerlMonks |
Re: Sorting data that don't fit in memoryby andreas1234567 (Vicar) |
on Oct 12, 2007 at 12:50 UTC ( [id://644465]=note: print w/replies, xml ) | Need Help?? |
I second the suggested database approach. Using your favorite database (BerkeleyDB, SQLLite, MySQL, PostgresQL, Oracle, IBM UDB, etc), apply indices to the sort columns, and do a SELECT .. INTO OUTFILE, dump or equivalent.
I work on MySQL databases with single data files exceeding 0.5Gb every day, where indexed searched are more than fast enough for my purposes. Dumping whole tables of those sizes requires significant I/O, so be patient.
-- Andreas
In Section
Seekers of Perl Wisdom
|
|