Cache size for in-Memory database

[Ruslan Zasukhin]

On 11/15/05 1:22 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

Hi Ed,

> What is the affect of selecting various cache sizes when your database resizes
> in RAM only?

RAM DB do not use Cache at all.
 
> If you're running on MacOS X with virtual memory is there any good reason to
> or not to just create a very large cache size?

For RAM database -- you can make it very small e.g. 1MB.


Note, virtual RAM of OS is not very good for DB tasks.
This is why each DBMS have own cache. It is more specific and effective

-- 
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]