Pokka,

> I am testing FB's performance on large database (>4GB). I found that
> the speed of the first query after reboot is substantially slower
> (around 5 seconds) than normal even though it is a simple query on
> index. I then disable the Windows cache in firebird.conf and the
> performance is consistently slow (~5 seconds). So the slow

performance

> after reboot is likely to be due to the windows cache.

No, not at all.

> While it is understandable that windows cache can impove performance,

I

> am amazed at the degree firebird depends on Windows cache. I have
> conducted a similar test (same data, same query) on postgresql and its
> speed after reboot is very fast.
>
> Is there anything to do with the fundamental design of FB?

What you are seeing is not a direct dependency on the Windows cache but
rather the cost of loading the database schema details to
prepare/optimize the query.

To help you analyze the problem further, please provide:

- the version of FB you are using
- the database header statistics (GStat)
- the SQL query you were executing


Sean