Subject | Re: [firebird-support] Isolation Level |
---|---|
Author | Paul Beach |
Post date | 2003-06-24T14:23:45Z |
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_handle_dead
Paul
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]