in reply to Re: Replacing SQL with perl
in thread Replacing SQL with perl

whoa there! ORDER BY makes almost any Database, especially Oracle, crawl. And if you have multiple app servers, you might want to do your sorting outside the database. depends of course, but ORDER BY is a killer.

Replies are listed 'Best First'.
Re: Re: Re: Replacing SQL with perl
by extremely (Priest) on Dec 07, 2000 at 14:39 UTC
    Not if the indexes are set up correctly. Anything you ORDER BY on often enough to optimize, optimize with an index.

    --
    $you = new YOU;
    honk() if $you->love(perl)