--- In firebird-support@yahoogroups.com, Alexey Kovyazin <ak@...> wrote:
>
> 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]
>