At 09:52 PM 6/06/2011, Maya Opperman wrote:

>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)

Make sure the report is not running in ReadCommitted isolation.

>They are using Firebird classic FB 2.1.5 (and have been on 2.1.3 and 2.1.4 with the same issue)

You have an unreleased snapshot on a production site????

./heLen