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.

Reply via email to