That's cache warmup, basically.
The only way to circumvent this is to warm up the caches yourself.
If you are running some kind of long-lived server application, it's fairly normal to run a thread at startup that
executes some common queries to warm up the caches.
On 2015-04-09 12:13 PM, Cecil Westerhof wrote:
The first time I send a query to H2 it takes around 25 seconds. All subsequent
queries are ready in less as a second. Is
this normal? Can I circumvent this?
--
Cecil Westerhof
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.