|Subject||Re: [firebird-support] Re: How to implement SQLServer's WITH(NOLOCK) statment?|
> It is the other way around, the with(nolock) hint means that thePerhaps you are using by accident, either
> SELECT doesn't get locked by anyone.
> This is what I want.
* the NO RECORD_VERSION option when starting a transaction, or
* the WITH LOCK clause in a concurrent SELECT statement
Both things happily decrease multi-user concurrency performance.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and