> At 07:13 PM 15/06/2005, you wrote:
> >I have read that "read commited" should not be used, because it
> >is "broken".
>
> In what way is it broken?

I was referring to Jim Starkey's comment on May 01, 2005: Subject:Re:
[Firebird-devel] How does Firebird responds to transaction lifetime

> Result sets held for long periods should be in Read Committed

isolation and

> in Read Only mode. Long-running read-write transactions all have

the

> potential to get "stuck", from the POV of garbage
> collections. Long-running read-only *snapshot* transactions will

also

> cause this since, unlike Read Committed, snapshot transactions have

to

> provide a repeatable read.
>
> ./hb

So is it best to use Read/Read Committed instead of Read/Snapshot?

Also, can you change your transaction type without committing or
rolling back? Say from Read to Read/Write?

Thanks