[V4MD] query speed

[Martin Kloss]

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?

>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? The db in this app is read only anyway,
so nothing will be added to the database.

Martin.


Martin Kloss

Like the author? Buy the book:
http://www.amazon.de/exec/obidos/ASIN/3934358322/lingmmugd

Need music? http://www.selling-sound.com

Get your daily dose of Lingo: http://www.lingopark.de