Subject | Re: [firebird-support] slow query at first execution |
---|---|
Author | Marco Parmeggiani |
Post date | 2004-04-28T10:12:48Z |
In data Wed, 28 Apr 2004 11:19:29 +0200, hai scritto:
if my guess that the query is truly that one (i'm going to test it more
deeply), what i do is to retrieve the PKID of a row that has been inserted
some seconds earlier. so, i suppose, it's already in cache (this is db low
level voodoo i don't know).
i will come back with more info when i'll have it.
thanks
ciao
> I believe that when the query is executed for the first time, servernot sure about that.
> retrieves records from disk
> Subsequent querys are finding the records in cache
if my guess that the query is truly that one (i'm going to test it more
deeply), what i do is to retrieve the PKID of a row that has been inserted
some seconds earlier. so, i suppose, it's already in cache (this is db low
level voodoo i don't know).
i will come back with more info when i'll have it.
thanks
ciao