Re: Flat File Processing

In article <ao3k7a$h3r$1_at_ctb-nnrp2.saix.net>, Billy Verreynne <vslabs_at_onwe.co.za> writes:
>Oracle 8.1.x and later on HP-UX/Linux/Solaris..
>
>How effective is UTL file ito of performance? If having the choice between

>doing flat file processing either via Pro*C, or via PL/SQL using UTL file,

>what would you choose and why? (pretend that SQL*Loader is not an option
>and that db access is a requirement as part of the processing).
>
>Basically what I would like to know if anyone has done some serious
>intensive file processing via PL/SQL and if one should consider this as an

>option instead of using Pro*C.
>
>--
>Billy

I have never ran any performance tests, but I was told by Oracle support back when utl_file was new that if your files were large that Pro*C IO was faster since OS IO via the package required additional overhead. But I have not noticed any performance issue with small files.

However, as utl_file is limited to reading and writing on the db server using Pro*C allows you to run the application from an application server rather than on the db server, which is an important consideration.

HTH -- Mark D Powell --

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net