Hi, Ever since the reuseSpaceBtreeIndex was introduced, I saw a significant performance loss. My program does a lot of short read/ update/deletes and this was just too expensive. I set it to false right after loading the database class and order was restored.
Now, there's a new problem. My software is an Eclipse plugin. It turns out that other plugins started using H2 (most noticeably the next version of PDT, 2.2) . This means, that changing this property may affect other plugins since this is a system wide property. I would like to be able to control this in the connection level, by setting REUSE_SPACE_BTREE_INDEX=FALSE. Thanks, Zviki -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=.
