Slow start up times

[Ruslan Zasukhin]

On 16/2/08 5:19 PM, "jda" <jda at his.com> wrote:

>> Not so easy I think.
>> 
>> Most DBMS have such caches. And such parameters.
>> 
>> Big FBMS have even few caches, and may be future we also will.
>> For example, they separate DataCache and IndexCache.
>> 
>> 
>> DBMS always must be considered as system which work with DATA FILE
>> which is
>> MANY MANY MANY times bigger of RAM, so you cannot allow to DBMS self
>> allocate more and more. You see?
> 
> Hi Ruslan,
> 
> I set my cache to 8 MB, which is good for several thousand records.
> That's not so large. It has to increase to maintain speed if one gets
> to 5000 records or more, and so on.

Up to which size, Jon?

E.g. Some mature DBMS have size MaxRamUsage, so you set it to 400MB.
But then how this differs from CacheSize = 400 ?!
 
> I realize that Valentina can be
> used for millions of records and many gigabytes of data, and perhaps
> that's what you mean when the data file is many times larger than RAM.
> But for more modest applications having a user-defined cache is
> cumbersome and, I think, unnecessary. It would be *much* better if
> Valentina allocated extra cache when needed -- it would be transparent
> to the user on OS X (I can't speak for Windows).

This is not related to MAC OS X or Windows at all
 
> This may be difficult to implement, I can't say, but Valentina would
> act like any other Mac OS X app if it did this, and it would make my
> user's lives easier (and mine, too, since I have to do tech support
> and it doesn't do any good when people complain that as their database
> grows, or they open more than one database at a time, it is "slow"! --
> the solution is to tell them to increase the cache and restart the app).

At last of end you SELF can implement some strategy against of this In your
app. Check then size of your db, and get cache size based on this info

Easy ?


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