Jared Still <[EMAIL PROTECTED]> writes:
> If you are working with Oracle, or any database for that matter,
> one of the cardinal performance rules for programming is to do
> it in SQL in possible. It is much faster than anything you
> can write in Perl, or any other language for that matter.
>
>
> If you can, it is usually most effecient to handle one row at a time.
If you are working with Oracle, or any database for that matter,
one of the cardinal performance rules for programming is to do
it in SQL in possible. It is much faster than anything you
can write in Perl, or any other langua
> Working with an Oracle database, there are several ways to fetch rows
> from table. In terms of performance which best? Here is a snippet from
> an existing script, are there ways to improve it?
If you can, it is usually most effecient to handle one row at a time.
Perl puts a lot of effort and
Working with an Oracle database, there are several ways to fetch rows from table. In
terms of performance which best? Here is a snippet from an existing script, are there
ways to improve it?
...
my $sql = qq { SELECT a.duns_num, b.name, c.last_upd, c.start_dt, c.end_dt FROM
$schema.s_org_ext
