Re: Faster option than utl_file
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: GMei@xxxxxx
- Date: Wed, 22 Feb 2006 10:45:46 -0800
Perl is also significantly faster than sqlplus at writing to a file.
YMMV, but I've seen up to 100% faster, dependent on platform
and Oracle version.
I tested it just now on RH Linux, Oracle 10.1 and Perl was
about 20% faster.
Jared
On 2/22/06, Guang Mei <GMei@xxxxxx> wrote:
>
> If you can use sqlplus to do the job, I found that spool is faster than
> utl_file.
> Or you can use perl's print , it is faster than utl_file.
> But if you have to use utl_file, instead of writing out each short line,
> you can concate the string to make it long enough, then write it out once
> (the limit is something like 32K).
>
> HTH.
>
> Guang
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of John Dunn
> Sent: Wednesday, February 22, 2006 11:04 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Faster option than utl_file
>
>
> I find utl_file too slow for reading and writing large text files.
>
> In fact it seems faster to read/write files from a Windows Visual Basic
> client application over NFS then to read/write using utl_file on the
> server.
>
> Is there a faster alternative? Or any way to tune utl_file?
>
> Platform is Oracle 9i on AIX 5.
>
> John
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
