in reply to Iteration speed

Sometimes, if we don't have a right tool, no matter how efficient we try to become it may not be possible.
I would seriously consider a well developed RDBMS (like oracle). They have invested several thousand man years of research to optimize joins and sorts and may not be worth to reinvent the wheel.
There are specific perl books written on this subject. (I have not read the book, so can't comment)

Replies are listed 'Best First'.
Re^2: Iteration speed
by tachyon (Chancellor) on Jun 15, 2004 at 18:59 UTC

    A RDBMS is almost never the solution where the problem reeks of algorithm.

    cheers

    tachyon

      The context in which I mentioned was that RDBMS companies have been refining join/sort algorithms for years and be more useful to just use it, rather than refine/redefine again.