| Subject | RE: [firebird-support] Occasional unexplained Slow down |
|---|---|
| Author | Helen Borrie |
| Post date | 2011-06-06T20:27:41Z |
At 12:01 AM 7/06/2011, Maya Opperman wrote:
./hb
>>>Running a report, which just executes one large query, that returns many rows, seems to be fine. It's the opening of a screen that executes 5-10 queries to get various information from various places that seems to be the main problem. (changing the program to a single query isn't really viable)OUCH!
>
>>Make sure the report is not running in ReadCommitted isolation.
>
>Reports (which ARE fast) run with the following transaction settings:
>
>read
>read_committed
>rec_version
>nowait
./hb