Not getting far with 1.4. I realized I could use PageStore by setting MVCC=FALSE, but the performance is pathologically slow, for me. My test, which takes 28 seconds in 1.3, has run for 20 minutes without completing, with 1.4.
I rebuilt the database table, to be sure it wasn't a 1.3 vs. 1.4 data file problem. Got the same result. The sampler in visualvm still shows all the time being consumed in PageStore.getPage. Whatever the problem, it seems to be dramatically worse in 1.4. ;) On Sunday, December 11, 2016 at 12:13:09 PM UTC-8, Brian Craft wrote: > > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
