Letting the datbase do the sort is a good approach, but I was hoping for a more general, memory efficient solution that allows for arbitrary perl comparison routines.
in reply to Re: Re: Heap sorting in perl
in thread Heap sorting in perl
Its a common enough situation that I would like to create a subroutine that returns the rows I want and takes a database handle, a sorting coderef, M, and an optional offset. I'm envisioning something like:
The question is, is there a perl heap implementation that would be suitable for implementing the above sub. Heap.pm seems like the obvious choice, but I have doubts about its current status.
my $sortedrows = db_heap_sort($dbh, $coderef, $M, $offset);
I have emailed the Heap.pm author, and will follow up with any new information I find out.