[V4MD] query speed

[Ruslan Zasukhin]

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

Hi Martin,

> I was just benchmarking my application and realized
> that when doing a search in my app the first query needed
> about twice the time of the second query. that didn't make
> any sense to me.
> 
> I'm taking the time a query needs to be returned from
> the database and if I'm doing the same query twice,
> the first one is always way slower than the second,
> 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.

> I tried giving more RAM to the db and deleting the index
> file. But the results are always the same. I'm using
> RegEx for the search, so the index is not really used
> on that one I guess. But do you have an explanation
> or idea how that can be?

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.

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