Hi, If you have many rows in the database, most likely the problem is that the values are randomly distributed. That way, caching is very inefficient.
Regards, Thomas On Friday, July 3, 2015, Noel Grandin <[email protected]> wrote: > Hmmm, that all looks fairly normal. > > Is it possible you could run the performance profiler > (see here: > http://h2database.com/html/performance.html#built_in_profiler) > and post the result? > > Either that or a self-contained test-case. > > -- > 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. > -- 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.
