Cache allocation for RAM-only databases.

[Ruslan Zasukhin]

On 11/16/05 8:24 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

>>>> 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
> 
> If a RAM DB does not use Cache at all, then what does it matter what you set
> the cache size to?

No matter

> Can you also make it very large, e.g. 100 MB, and if you
> do does that make any difference?

Just you waste your RAM. Sense ?


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