Re: Could Perl's DBI (DBD::Oracle) be faster than SQL*Plus?

Adam Monsen <adam_at_corp.classmates.com> writes:

> Tim Cross wrote:
> > Adam Monsen <adamm_at_wazamatta.com> writes:
> >
> >>>I then timed how long it took for Perl (via dbish) vs. the time it
> >>
> >>took for SQL*Plus to write one megabyte of data to disk. Perl took
> >>about twenty seconds to write a meg of data, SQL*Plus took about one
> >>minute.
> >>
> >>Yikes! Why the discrepancy? Is this test even valid? Is DBI::Shell
> >>really faster at dumping data than SQL*Plus?
> >>
 

> > 2. I notice you set the line length to 9000 and then you trim the
> > extra blanks. Do you expect any of your lines to be longer than 80
> > characters? I think its unlikely, so probably remove that line as
> > ell.
> I lowered this to 90 characters. This actually seemed to improve the
> speed... sqlplus took about 12 seconds to write a meg, while Perl took
> only 8.
>
>
Something else which I just thought of which might effect sqlplus performance is the result array setting (I think its SET ARRAY to change it). The default size for sqlplus is pretty small - possibly increasing this to something larger would improve performance.

Tim Received on Mon May 20 2002 - 00:35:26 CEST