Re^2: DBI with ORDER BY


No such thing as a small change
	PerlMonks

Re^2: DBI with ORDER BY

by YoungPups (Beadle)

on Mar 10, 2005 at 21:25 UTC ( [id://438426]=note: print w/replies, xml )

Need Help??

in reply to Re: DBI with ORDER BY
in thread DBI with ORDER BY

I just got my code review, and it sounds like it was more of a philosophical objection on his part. He's of the opinion that you should handle sorting in your program rather than make the DB do it. I disagree (pretty strongly), but that is at least a reasonable objection.

Most places I've worked, the machines that hosted our DBs were much beefier than the machines we did processing on, so I always made the database do as much of the work as I could. Plus, it seems to me to be a bit like reinventing the wheel to sort the results of a query in your script when the DB can do it for you, and is specifically set up to optimize such a sort.

Anyway, it sounds like I had just misheard why he was asking other coders to avoid ORDER BY statements.

Comment on Re^2: DBI with ORDER BY

Replies are listed 'Best First'.

Re^3: DBI with ORDER BY
by punkish (Priest) on Mar 10, 2005 at 22:16 UTC

Otoh, dbs are a royal pain in the derierre working with arrays and hashes kinda datasets. Once you get your data, nicely stuffed in an array, Perl can whip through it at close to machine speed (well, pretty much) searching for arbit. patterns and repurposing it as desired.

Maybe it is time for your code-reviewer to get a code review. ;-)

--
when small people start casting long shadows, it is time to go to bed

[reply]

In Section Seekers of Perl Wisdom