That does sound a bit drastic!. Would be good if the JIT compiler made everything 41 times faster :).

I'm really not sure sorry. I think if you can post a reproducible test case then someone will work it out!

Perhaps it might be that the OS is swapping your data to disk, and on repeated querying it swaps it back and keeps it in memory so is faster.

What I mean is, if you can post some more details then that should help us work it out.

Thanks, Ryan



On 3/10/2012 8:02 PM, snookerms wrote:


Am Dienstag, 2. Oktober 2012 14:36:17 UTC+2 schrieb Kartweel:

    Maybe this is due to the JIT compiler optimising it?

    On 2/10/2012 6:31 PM, snookerms wrote:
    > I'm running a SQL-Query the first time it takes 1540ms. The Second
    > time it take 749ms and the third time 503ms and so on.

    Thank You. But a Difference of 41 times faster?

--
You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/YP3SrTKKfvIJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to