Re: [firebird-support] what is the most fastest isolation level ?

2012-02-27 Thread Ann Harrison
On Mon, Feb 27, 2012 at 2:10 PM, eMeL wrote: > >> isc_tpb_read_committed + isc_tpb_no_rec_version > > I think it is. This use the less record version page and wait nothing > for updated records. It's great if you like getting an error every time you encounter an uncommitted write. Generally the

Re: [firebird-support] what is the most fastest isolation level ?

2012-02-27 Thread Ann Harrison
On Mon, Feb 27, 2012 at 3:38 AM, nathanelrick wrote: > > what is the most fastest isolation level ? > i know the behavior of each, but i need to know the difference in speed / > resource usage between each of them ... > > isc_tpb_concurrency > isc_tpb_consistency > isc_tpb_read_committed + isc_tp

Re: [firebird-support] what is the most fastest isolation level ?

2012-02-27 Thread eMeL
> isc_tpb_read_committed + isc_tpb_no_rec_version I think it is. This use the less record version page and wait nothing for updated records. eMeL

[firebird-support] what is the most fastest isolation level ?

2012-02-27 Thread nathanelrick
hello, what is the most fastest isolation level ? i know the behavior of each, but i need to know the difference in speed / resource usage between each of them ... isc_tpb_concurrency isc_tpb_consistency isc_tpb_read_committed + isc_tpb_rec_version isc_tpb_read_committed + isc_tpb_no_rec_versio