Subject Re: [firebird-support] Re: How to implement SQLServer's WITH(NOLOCK) statment?
Author Thomas Steinmaurer
> It is the other way around, the with(nolock) hint means that the
> SELECT doesn't get locked by anyone.
> This is what I want.

Perhaps you are using by accident, either

* 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.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions