Thread: VERY SLOW UPDATES
This is my situation... My table has about 1.6 million records. I am trying to use the update command to insert new data. However, it is extremely slow--about 2 to 4 seconds per update. You can see my problem is I am trying to update 40,000 records. Any insight or suggestion would be appreciated. -Ken PS I am currently wrapping my updates in a transaction block and indexes have been dropped. ______________________________________________________ Kenneth P. Grembowicz Oceanographic Databases Division, Code N51 Naval Oceanographic Office 1002 Balch Blvd. Stennis Space Center, MS 39522-5001 Tel: (228) 688-5675 Fax: (228) 688-5778 e-mail: grembowiczk@navo.navy.mil
* Grembowicz, Kenneth <GrembowiczK@NAVO.NAVY.MIL> [000818 09:08] wrote: > This is my situation... > My table has about 1.6 million records. > I am trying to use the update command to insert new data. > However, it is extremely slow--about 2 to 4 seconds per update. > You can see my problem is I am trying to update 40,000 records. > Any insight or suggestion would be appreciated. > -Ken > > PS I am currently wrapping my updates in a transaction block and indexes > have been dropped. I think that dropping indexes might be a bad idea particularly since the update must search for the row to be updated and probably is forced to do a sequential scan. I would put the index on the row of your UPDATE's where clause. -Alfred