Subject Is the cache guaranteeed to reside in physical memory?
Author Nando Dessena
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.