Yes we have different caches at different levels so subsequent queries will
be faster.

On Thursday, 9 October 2014, Anirban Mitra <[email protected]> wrote:

>
> Hi,
>
> We are using in memory H2 database in our production environment and using
> windows machine and 64 bit java.
>
> We are noticing the response time difference, when the same query executes
> subsequently after the first execution.
>
> e.g. if first execution is taking 9000 ms then same query next time is
> taking 4080 ms.
>
> Do we have any built in query cache or object cache for in memory H2 DB ?
> What could be the reason of this differences ?
>
> Thanks
> Anirban
>
> --
> 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]
> <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');>
> .
> To post to this group, send email to [email protected]
> <javascript:_e(%7B%7D,'cvml','[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