--- danyschaer wrote:

> I uploaded http://www.lex-doctor.com/daniel/danydata.zip (140 MB
> aporx); into it there is my full test database.

Unfortunatelly, I cannot download such big file (at least, not
quickly), so I probably won't test it. (Maybe you could upload a
metadata-only backup? and I'll use FlameRobin's test data generator to
add the same amount of records you have in your tables.)

However, looking at statement plan (even for your original query) it
does seem strange to me; 10 minutes is just too much, even for natural
read. So, I have a few questions:

- what is the hardward configuration of the machine?
- which operating system is it? Windows XP?
- do you maybe use .gdb for database file extension?
- did you change any of the default settings in firebird.conf?
- did you maybe set the flamerobin's option to fetch all records by
default?

Thanks,

Milan.