Hi Ivaylo, I am glad to hear that “Chunk not found” bug is no longer appear with latest build. That other discussion, you have mentioned, is related to a different performance problem, and according to Noel Grandin has been addressed in latest build, as well. Going back to your claim of slow “SELECT * FROM” - my experiments with 300000 rows, 7 column table shows that execution time with PageStore is prety much consistent across 1.3.175, 1.4.197 and latest snapshot. MVStore execution time in 1.4.197 is 1.5 times that, while in latest snapshot it’s 2.5 times faster than PgStore. So, apparently your case is different from mine in some important aspects (indexes, constraints, column tipes). I am afraid, that until you can provide simple, standalone, reproducible test case, not much we can do here.
-- 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.
