As I see now almost all RAM is unused, but Firebird create huge temp files during
heavy "selects". It is so far to start swapping. Should I create RAM disk for temp
files? It looks like old ugly DOS.

Helen Borrie wrote:

> At 10:38 AM 13-06-02 +0300, Andrew Guts wrote:
> >Hello, ib-support.
> >
> >How to configure Firebird or Interbase for using more than 65535 buffers per
> >database. Each buffer is a 4Kb, isn't it?
>
> True, if your database page_size is 4096 - since each buffer is one
> database page.
>
> >So server can utilize only 256Mb RAM, inspite of 2Gb avaliable. Gfix does not
> >accept more than 65535 buffers.
>
> You can have up to a 16Kb page_size in Firebird 1 - potentially your
> maximum cache size is 1 Gb. It doesn't make sense to set the default cache
> higher than it needs to be though - there is no point in starving the
> server to feed a large cache that is under-utilized. Also you don't want to
> make it so large that, at times, cached memory might need to be paged to
> disk - this defeats the purpose of caching.
>
> heLen
>
> All for Open and Open for All
> Firebird Open SQL Database · http://firebirdsql.org ·
> http://users.tpg.com.au/helebor/
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/