Home » SQL & PL/SQL » SQL & PL/SQL » Program taking a lot of time ..... needs optimization
Program taking a lot of time ..... needs optimization [message #36774] Wed, 19 December 2001 17:24 Go to next message
Vamsi
Messages: 9
Registered: December 2001
Junior Member
Hi,

I have a pl/sql procedure that inserts data into a table. I have to insert about 40000 records into the table. Each new record inserted is based on the previous values present in the table, so that one of the fields is unique throughout.

so before each insert a full table scan is made for checking if the same value exists or not. So, for 20000 records the program takes about 50 mins. Can we cut down this execution time by any means?

TIA,
Vamsi.

----------------------------------------------------------------------
Re: Program taking a lot of time ..... needs optimization [message #36780 is a reply to message #36774] Thu, 20 December 2001 02:37 Go to previous message
Phenoracle
Messages: 35
Registered: March 2001
Member
Hi,
when you insert a value into the table, you could hold the values in memory then do your calculation
to evaluate the next value to insert.

post me the query on my site or email me,if you
need some more help.

http://www.phenoracle.co.uk

Have fun

Phenom



----------------------------------------------------------------------
Previous Topic: Re: Ref Cursor Error
Next Topic: A question about triggers (I think!)
Goto Forum:
  


Current Time: Fri Mar 29 01:41:30 CDT 2024