Re: APPLICATION TUNING

BHAVESH PATEL wrote:
>
> Hi
>
> Can any one tell me the answer for the following questions relating to
> application tuning .
> Currently , I have a system which reads data from a flat file and stores it
> in a table after validations. For this we use UTL_FILE built-in package.
> This was working OK for now, it takes 15-20 min, to load 1000-5000 the
> records after validations. But now we are expecting a load of 50000 records
> to be read in and stored in the table after validations.
> I think loading the file thru a sqlloader into a temp table and then
> reading a temp table and validating the record and then inserting it into a
> master table. Which is the best method for the performance? Can anyone
> suggest me what to do or is there any other solution to this or Is there a
> better way to do same thing. I mean is there any other way to load the data
> into a table from a file after validation checks without using UTL_FILEs
> and also can you please tell me which is fastest, UTL_FILE operation which
> reads in one record at a time and validates it and stores it in a table or
> using a temp table and reading from a temp table. Hope to get a clear and
> descriptive answer.
>
> Thanks a lot for your kindness and have a nice weekend and a great day.
> Bhavesh

Sql*loader with direct path method should be the best solution i think. For syntax refer to Oracle utilities user guide. Direct path method has proven to be fast. Also you can do some validations using sql functions in the sql*loader.

-- 
*****************************************************************
"There are no strangers in life, only friends you've not yet met"
Srinivasan Sankar                         srinisankar_at_hotmail.com
*****************************************************************
P.S:- Replace "nospam" with "hotmail" while replying to me