> I am a bit concerned at using snapshot - isn't that like doing a dirty

read?

Not at all - Firebird doesn't support dirty reads.

Snapshot means so much as a frozen view upon the data, which, I think,
sounds exactly like what you need :)


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> At 01:04 PM 06/20/2003 +0200, you wrote:
>
> >Hi Tim,
> >
> >
> > > Checked with the development manager. What seems to be happening is

that a

> > > select query is run against the DB, with txn isolation of read
> >consistency.
> >
> >You might want to try an isolation of "snapshot" - this shouldn't block
> >any readers of the data.
> >
> > > When we try to make a sale (txn isolation of write consistency ) or

close

> >a
> > > shift, the sale or shift txn waits until the select is closed. In

other

> > > words, doing a select with read consistency seems to lock the record

set

> > > returned by the query.
> >
> >
> >With regards,
> >
> >Martijn Tonies
> >Database Workbench - the developer tool for InterBase & Firebird
> >Upscene Productions
> >http://www.upscene.com
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >---
> >Incoming mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.489 / Virus Database: 288 - Release Date: 06/10/2003
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>