Subject Re: [firebird-support] Isolation Level
Author Paul Beach
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_handle_dead

Paul
----- Original Message -----
From: Marcos Vinicius Dufloth
To: firebird-support@yahoogroups.com
Sent: Tuesday, June 24, 2003 2:28 PM
Subject: [firebird-support] Isolation Level


Hi. I'm having a problem with an app that uses BDE and Firebird. When
the server run a very extensive query, fetching about 140000 rows,
others users hangup until the query returns. The connection to this
query is made with ReadCommited. I figure out how I can change the
DRIVER FLAGS in BDE configuration to use some other isolation level.
And, using other isolation level this problem can be solved? Using
RepeatableRead maybe?

I'm using Delphi 5, BDE 5.11, Firebird SS 1.02 and Mandrake Linux 9.0.
Components are TQuery and TDBGrid.

Regards,
Marcos Vinicius Dufloth.



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]