Cache allocation for RAM-only databases.

[Ed Kleban]

On 11/15/05 11:55 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?  Can you also make it very large, e.g. 100 MB, and if you
do does that make any difference?