Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE vs PRO*C/C++
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
![]() |
![]() |