thanks helen

so, you mean there will not be any problem with transaction having following
parameters

read_committed
nowait
recversion


Thanks
Kamlesh




"Helen Borrie" <helebor@...> wrote in message
news:5.2.0.9.2.20040223081858.01da6610@......

> 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
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>