Hi Andre It is hard to suggest a best approach without understanding your application. Usually if you are going to lock 250 records at the same time in the same file, you should be considering escalating to locking the File.
This is a bigger problem for RDBMS, which is why they prefer optimistic locking to pessimistic locking. If File Locking is not acceptable, you should consider moving to an optimistic model. With Large number of records being locked, you could be increasing youre chances of deadlock situations as well. Regards David Jordan > > With our current settings we can have a maximum of 250 locks in one group; > this means most certainly for auto numbers we can only lock records 1000 > to > 1249 without getting an abort and a rollback because a new lock cannot be > acquired. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
