I believe this can also be caused by the OS block caching, which won't be affected by restarting H2. I see this behavior:
1) Run query in embedded app, it takes 15 sec 2) Shut down and run the same query in console, it takes 200 ms 3) Run it in the app again after restarting, it takes 200ms 4) Run a novel query in the app, it takes 15 sec This makes it seem like the disk io is the bottleneck, though I note that my disk usage is always fairly low. On Wednesday, June 9, 2010 9:44:48 PM UTC-7, Thomas Mueller wrote: > > Hi, > > It could be a caching issue. To make sure, could you test again with > the H2 Console, but ensure that the database is closed (no .lock.db > file), then open a connection, and run this query (no other queries > before that)? > > One way to speed up multi-dimensional queries is: > http://h2database.com/html/features.html#multi_dimensional > > Regards, > Thomas > > -- 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/groups/opt_out.
