Insert Statement Performance Degradation
582870Jul 26 2007 — edited Jul 26 2007Hi There,
So my java application is updating a row in 1 table (TableA) and inserting about 20 rows in another table (Table B). This code iterates about 30,000 times.
The first time the above code is run and TableB is empty the processing is very quick. It will run to completion in about 6 minutes. But when I continue to run the processing and the size of TableB grows, the run time increases. For Example, I ran the processing about 30 times and the last time took around 30 minutes.
Can anyone suggest what the problem might be, or what I can do to increase performance?
thanks,
John