If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to run an update query without cacheing ?
Hi-
I have this suspicion that if I were to run an update query w/o cacheing an undo file, the whole thing would run faster. Does this sound reasonable? Is it possible? I am running MSA97 / MSA03 and linking via ODBC to db2/400. I want to update many records and it takes all day. When I run an sp on the 400 it is done before the enter key comes up. I think the reason for the lag is that MSA is writing the records out somewhere for an undo. Thanx Todd |
Thread Tools | |
Display Modes | |
|
|