J
Jim Bunton
I have a loop WITHIN a transacton which copies data from one table to
another.
ie before the loop BEGINTRANS and after exiting the loop COMMITTRANS
At present this is required to process about 86000 records
It exits with error 'File sharing lock count exceeded - Increase
MaxLocksPerFile registry entry'
I have searched the registry for maxlocks - not found as far as I can see
What to do?
I would like to know how to find this entry to find what it is set at so
that I can increase it.
However
I have an alternative strategy. I could COMMIT every few hundred/thousand
times round the loop. The use of 'transaction' is only really necessary
after each iteration BUT I understand that this will increase the processing
time - ie starting and committing a transaction at the completion of each
iteration.
ALSO, I suspect that if I increase MaxLocksPerFile it MAY be that at some
point I will encounter performance problems due to having to buffer the
transaction to disk and back]
another.
ie before the loop BEGINTRANS and after exiting the loop COMMITTRANS
At present this is required to process about 86000 records
It exits with error 'File sharing lock count exceeded - Increase
MaxLocksPerFile registry entry'
I have searched the registry for maxlocks - not found as far as I can see
What to do?
I would like to know how to find this entry to find what it is set at so
that I can increase it.
However
I have an alternative strategy. I could COMMIT every few hundred/thousand
times round the loop. The use of 'transaction' is only really necessary
after each iteration BUT I understand that this will increase the processing
time - ie starting and committing a transaction at the completion of each
iteration.
ALSO, I suspect that if I increase MaxLocksPerFile it MAY be that at some
point I will encounter performance problems due to having to buffer the
transaction to disk and back]