Subject | Isolation Level |
---|---|
Author | Marcos Vinicius Dufloth |
Post date | 2003-06-24T13:28:52Z |
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.
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.