Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

a harmless sort? More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Sort in the database (Score:2)

by autarch (914) on 2005.04.01 12:05 (#39345) Homepage Journal

Sort your data in the database. This will be faster. It also scales better when you just want part of the result set, because you can use LIMIT (or whatever your DB supports).

Reply to This
- Class::DBI considered a hinderance (Score:1)
  
  by Aristotle (5147)
  
  Yeah, what autarch said.
  
  This is why gave up Class::DBI – it very nearly forces you to do on the Perl side what should be done at the SQL level because it makes it way too difficult to do the latter. First you run into a wall of no documentation, then you often have to put up with annoying verbiage. After reading the source for 15 minutes, I think the following will do what you need:
  CPANTS::Distro::Kwalitee->set_sql( all_by_kwalitee => 'SELECT __ESSENTIAL__ FROM __TABLE__ ORDER B

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.