Cache Size

[Ruslan Zasukhin]

On 26/2/07 10:15 AM, "Beatrix Willius" <bwillius at gmx.de> wrote:

Hi Beatrix, 
 
> what's nowadays the recommendation for the cache size of Valentina (V2RB on
> MacOS)? My databases usually have >100.000 records and the size is >1 GB.

Well, v2 can easy and effective work with cache even in 50-100+MB.

In ideal to get best performance Cache should be enough to keep the most hot
files. This is e.g. Hot Indexes.

So try to set 50 or even 100MB if your RAM is e.g. 1-2Gb.

Cache still should not be more than 50% of available on start RAM
Valentina self correct this if needed

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]