Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE vs PRO*C/C++

Re: UTL_FILE vs PRO*C/C++

From: Rod Corderey <Lane_Associates_at_compuserve.com>
Date: 1998/05/27
Message-ID: <356C1D0B.44412715@compuserve.com>#1/1

Hi Patrick,

I would expect UTL_FILE interface to be marginally slower that C++ file handling, but first have you checked which aspect is slow.

If the bottle neck is in the data retreival then moving the same into ProC will probably produce the same result.

The other question would be how supportable would a C++ alternative be and would it need supporting after the event. ie is there a case for server side code over and above the performance.

regards

Rod Corderey
Lane Associates
Lane_Associates_at_Compuserve.com
http://www.Lane-Associates.com

Patrick Drouin wrote:
>
> Hello everyone,
>
> I am using UTL_FILE routines to generate huge flat files from the
> content of the database. It turn out that the UTL_FILE routines seem to
> be very slooowwww.
>
> I am thinking of writing these routines using PRO*C/C++ to speed things
> up. Anyone ever went this way? I believe it might speed things up quite
> a bit.
>
> Any information/tips will be welcome.
>
> Regards,
> P
Received on Wed May 27 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US