[V4MD] query speed

[Ruslan Zasukhin]

on 1/30/04 10:28 AM, Martin Kloss at martin.kloss at gmx.de wrote:

> At 00:38 30.01.2004, you wrote:
>>> i.e. first query takes 3.2 seconds, the second query
>>> (the same SQL query) takes only 1.8 seconds.
>> 
>> I think this is result of caching.
>> Remember: DBMS can be cool and warmed.
> 
> Hmm, sorry I can't remember seeing any caching features for V4MD.
> Can you say what exactly you mean?

    ValentinaInit( cacheSize )

When you say 10MB this means Valentina allocate in RAM 10MB of space to
cache disk data


>> Wait.
>> First query is slow.
>> Second, third, 4th, ... Fast, yes?
>> To get slow again, you need QUITE app, i.e. Kill cache, yes?
>> Then everything is clear -- caching.
> 
> Kill the cache? How?

    ValentinaShutDown() do this.


> The db in this app is read only anyway,
> so nothing will be added to the database.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------