| Subject | Is the cache guaranteeed to reside in physical memory? |
|---|---|
| Author | Nando Dessena |
| Post date | 2002-09-27T15:19:21Z |
Hello,
I have to work out a -buffers setting that could be a reasonable default
for both stand-alone installations and multiuser with a server
(presumably more RAM that the stand-alone thing).
Given that I have 4KB pages, I think 5000 pages is a suitable value for
our database, but was wondering: will IB try to allocate upto 20MB (4 x
5000) even if they're gonna come from the pagefile, or will it stop when
there's not enough physical memory available?
I don't want to keep the 75 page server default, but I obviously don't
want to defeat the cache.
Does aanyone know for sure? I'm using IB5.6.
TIA
--
____
_/\/ando
I have to work out a -buffers setting that could be a reasonable default
for both stand-alone installations and multiuser with a server
(presumably more RAM that the stand-alone thing).
Given that I have 4KB pages, I think 5000 pages is a suitable value for
our database, but was wondering: will IB try to allocate upto 20MB (4 x
5000) even if they're gonna come from the pagefile, or will it stop when
there's not enough physical memory available?
I don't want to keep the 75 page server default, but I obviously don't
want to defeat the cache.
Does aanyone know for sure? I'm using IB5.6.
TIA
--
____
_/\/ando