I am doing some experimentation on locking and have noticed that when you open a record set and update to it lie this:
cnn.CursorLocation = adUseClient
rstTestLock.Open "zz_LockTest", cnn, adOpenStatic, adLockOptimistic, adCmdTable
It processes a lot slower that if you do it like this:
cnn.CursorLocation = adUseServer
rstTestLock.Open "zz_LockTest", cnn, adOpenDynamic, adLockPessimistic, adCmdTable
I basically got a loop to write to a backend database (on the same PC) 10000 times. The first method takes over 50 seconds but the second method (adUseServer) takes only 5 seconds...!!??
Anybody got any thoughts or ideas?
cnn.CursorLocation = adUseClient
rstTestLock.Open "zz_LockTest", cnn, adOpenStatic, adLockOptimistic, adCmdTable
It processes a lot slower that if you do it like this:
cnn.CursorLocation = adUseServer
rstTestLock.Open "zz_LockTest", cnn, adOpenDynamic, adLockPessimistic, adCmdTable
I basically got a loop to write to a backend database (on the same PC) 10000 times. The first method takes over 50 seconds but the second method (adUseServer) takes only 5 seconds...!!??
Anybody got any thoughts or ideas?
