Re: Tools vs C

On 16 Aug 1997 07:16:09 GMT, cphdcbl_at_ted.cs.depaul.edu (Brian Li) wrote:

>
>Dear Netters:
>
>I am new to Oracle. I wonder what are the trade-offs between using
>Oracle tools such as SQLLoader and a native C program on dataload.
>What is the more efficient approach to load data if performance is
>a more important issue than that of ease-of-use and portability.
>
>Same question for query processing - C vs tools.
>
>Thanks in advance for any info and advice.
>
>Brian Li

As far as SqlLoader v C loader goes, SqlLoader winds hands down... as it has a feature called Direct Load which is probably the fastest way to load data. Please note that you can use the direct load only if the client and the server are on the same platform (NT and NT, HPUX and HPUX etc.)... not neccessarily the same box.

As far as query processing goes, client tools do not perform any of the processing... the server does. The tools just submit the query to the db and fetch the results.

-sm Received on Mon Aug 18 1997 - 00:00:00 CEST