Cache allocation for RAM-only databases.

[Ed Kleban]

On 11/16/05 12:29 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

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

So it ends up allocating RAM that it simply doesn't use.  If that's what you
mean, then yes it makes sense.

So why not allocate a cache size of 0 ?