Got it, Dany. When I just turned on the PC, I got the same problems as
you do - even without installing FlameRobin (I've never tried it, just
used IB_SQL and Database Workbench all the time, and didn't fancy
learning a new interface this evening). I never bothered to check
whether it took 8 or 15 minutes, it was enough for me to see that it
didn't return anything in the first three minutes.

I also discovered that if I issued 'SELECT count(*) FROM MOVI' before
doing the select, then the select was quick, whereas it didn't help
trying 'SELECT count(*) FROM PROC'.

So, I'm convinced it is an error (or something similar) and not a
general support question at all. I'll write a bit about it in
firebird-devel, which is the correct place for discussing issues with Fb
2.1 that aren't simply general questions relevant for other versions as
well.

Sorry for this long thread here, in retrospect it is easy to see that it
shouldn't have been on this list at all.

Set

danyschaer wrote:

> Set,
>
> Ok, thank you, I will wait your test report. Just want to say a few
> things.
>
> 1. Do my test just with lasts standard versions of Firebird 2.1
> Superserver and FlameRobin. Nothing else. FlameRobin reports the
> minutes/seconds at the end of statistics (label Execute time).
>
> 2. Dont forget to give another try using MaxFileSystemCache = 0. I
> think it will help you to see the problem (I mean what happens when
> Firebird can't take advantage from filesystem cache).
>
> Dany