How can I select pageStore in 1.4? I haven't found the option in the docs. If I've written the file with 1.3, perhaps 1.4 will find an engine setting in the db?
So I understand, is getPage() fetching from disk? Using a profiler, getPage() is the top hot-spot. I'm not sure why the profiles don't descend into the methods called by getPage(), as it seems to mostly call other methods, rather than doing work itself. Perhaps iostat shows no disk activity because the OS has cached all the relevant pages, and getPage() is spending its time pulling from the OS caches. In that case, I might expect the h2 cache size to be important, but I haven't been able to measure any effect from increasing the cache size, even when repeating the same sequence of queries. On Saturday, December 10, 2016 at 9:04:39 PM UTC-8, Noel Grandin wrote: > > multi_threaded was very very experimental back then. > > it's getting better now, and with current master I'm running it myself > (with the MVStore) engine in my QA to flush out issues. > > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.