Hi Thomas, i also tried the newest version with PageStore and then performance dropped even more.
Testing jdbc:h2:C:\h2-bdb;MV_STORE=FALSE;MVCC=FALSE 100.000 in 1544 100.000 in 1717 100.000 in 3668 100.000 in 9969 100.000 in 19164 100.000 in 24247 100.000 in 26944 100.000 in 27150 100.000 in 27513 100.000 in 28763 Selecting 100000 Select done in 5055 Close in 532 Unfortunately I cannot use the tricks described. I need to store the HASH one at a time and have fast read access from the beginning. I'm developing a single threaded client app that should use as little disk space and CPU usage possible. Why is it that MVStore ends up using 10 timers more disk space in this test? -- 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.
