At 12:33 AM 23/02/2004 +0530, you wrote:

>dear friends
>
>i read somewhere that long running transaction does not affect interbase 7
>server performance if transaction is read only ??
>
>does long running read only transaction affect firebird server (1.5 rc9)

If ia read-only transaction is in Read Committed isolation the OAT won't
get stuck on it. In Snapshot isolation, of course, the server has to
preserve the transaction's view, so it's like any active read-write
transaction in that respect.

The same applies to InterBase 7.

/hb