Ann,

> Figure out how big your database is, leaving room for expansion,
> divide that
> number by your page size and the result is the number of pages in the
> database, give or take Window's file size measurements, and that should be
> your cache size.
> By allocating that much memory to the database page cache, you reduce the
> amount of memory available for other uses, like the system page cache.
>

if Marcelo wants to achieve better performance, not just put database to
the memory, I think it's good to mention here that performance could be
worse in this case. It can be very bad in case of Classic/SuperClassic
and slightly worse in case of SuperServer (he did not indicate what
architecture he uses and how many users are there).

Certainly such vacuous cases are interesting to discuss, but I think
people in support forum can recognize it as signal to change their
Firebird configurations, which will lead to unforeseen consequences.


Regards,
Alexey Kovyazin






[Non-text portions of this message have been removed]