Re^2: Sorting data returned from DBI ...

Thank for the link and uber fast response! That was what exactly what I needed. I was going through the DBI documentation this morning but it had not occurred to me that you could use ORDER BY like that.

-mox

Comment on Re^2: Sorting data returned from DBI ...

Replies are listed 'Best First'.
Re^3: Sorting data returned from DBI ... by davido (Cardinal) on Dec 10, 2006 at 16:48 UTC
In general, if you can push some task off onto the database (out of Perl's hands) you're better off. This is only a general rule of thumb, but it seems to hold in most cases. When in doubt, let the database do the work. In this case, you were already sorting once in the database, and then contemplating sorting again within Perl. That would mean performing two O(n log n) exercises instead of one. Dave	[reply]

Replies are listed 'Best First'.

Re^3: Sorting data returned from DBI ...
by davido (Cardinal) on Dec 10, 2006 at 16:48 UTC

In general, if you can push some task off onto the database (out of Perl's hands) you're better off. This is only a general rule of thumb, but it seems to hold in most cases. When in doubt, let the database do the work.

In this case, you were already sorting once in the database, and then contemplating sorting again within Perl. That would mean performing two O(n log n) exercises instead of one.

Dave

[reply]