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

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]