Maximum practical cache size

[Matthew Jew]

Hello!

I am using Valentina 4.0 ADK for C++ on Mac OS X.

On my deployment machine, I usually have a good amount of RAM (2 GB or  
4 GB).
Not many processes are running on the deployment machine, so there is  
often 1.5 GB of unused/inactive memory
(according to both the Activity Monitor application and the "top"  
command.)

Is there a practical limit to what Valentina can use as a cache setting?
I know more cache is (usually) better, but is there a point past which  
having too much allocated
can be a detriment to performance?
(I mean, aside from allocating so much to the Valentina application  
that the rest of the system
  has insufficient RAM.)
If we leave plenty of RAM for other processes, is there a point at  
which we begin to hurt Valentina's speed?
(Due to the overhead of managing the contents of a gigantic DB cache.)

I currently have the cache set to 20 MB.

I was thinking of increasing it to 1,024 MB (1 GB).

- Matthew