Performance problem [message #20158] |
Thu, 02 May 2002 10:55 |
Dave
Messages: 92 Registered: August 1999
|
Member |
|
|
Hi there,
I have a performance problem on 7.3.4. I have a tcl program which processes approx 100,000 records at a time, and then uses expect to spit out the SQL, this takes about 5-6 secs. Then I perform an update to a table, and depending on the the month and region (both are indexed) it increments 1 of 8 other fields by 1. This takes upto 5 minutes and it's all in Oracle. Can anyone give me any idea as to why this is the case?
Thanks in advance,
Dave
|
|
|
|