|Subject||Re: [firebird-support] Re: How to implement SQLServer's WITH(NOLOCK) statment?|
At 10:24 PM 14/04/2008, you wrote:
>From the SQL server help file:You don't have to do anything in Firebird to achieve it. Firebird implements multi-user concurrency in an entirely different way to poor old SQL Server. It's called "multi-generational architecture". ;-)
>"In SQL Server, a SELECT statement with the default isolation level
>of Read Committed causes S locks being taken and released on rows as
>they are read. Although this enforces the isolation level, it means
>that a SELECT statement waits if an incompatible lock exists on a row
>for which an S lock is required. When the NOLOCK hint is specified,
>the SELECT operation does not try to take the S lock and the data is
>read. Although this lets the operation succeed, it also means that
>the SELECT statement can read uncommitted data."
>In practice what it means that select statments never get locked. and
>this is what I'm tring to achieve.