| Subject | Re: [ib-support] How to utilize maximum memory. |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-06-13T08:30:12Z |
At 10:38 AM 13-06-02 +0300, Andrew Guts wrote:
database page.
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/
_______________________________________________________
>Hello, ib-support.True, if your database page_size is 4096 - since each buffer is one
>
>How to configure Firebird or Interbase for using more than 65535 buffers per
>database. Each buffer is a 4Kb, isn't it?
database page.
>So server can utilize only 256Mb RAM, inspite of 2Gb avaliable. Gfix does notYou can have up to a 16Kb page_size in Firebird 1 - potentially your
>accept more than 65535 buffers.
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/
_______________________________________________________