Hi Andrei, I built today from the source (latest merge on the master branch 2018-08-21 15:01:11) and we have tested whether the IllegalStateException above occurs when the newest H2 jar is used. The error does not appear any more.
However, the performance issues are still existing. I compared the SQL Query execution times of some SQL statements between MVStore and PageStore and observed the following differences: - Inserts perform equally good for both - The execution times for Select-queries on a 7 column table having more than 305 000 rows are 2-3 times larger for MVStore as for PageStore. Even the execution times for queries such as 'SELECT * FROM tableName' are much larger for MVStore as for PageStore. In my case testing this query in Squirl I observed execution times on MVStore nearly equal to 4 sec and on PageStore nearly equal to 1.5 sec. We have, for example, one test case where we insert a huge amount of data to H2 and then read that data and write it to an Excel file. The execution times for inserting the data were similar, whereas for selecting the data 4 times larger for MVStore. The gap is obviously much more than 20-40%. Greentings Ivaylo Am Mittwoch, 22. August 2018 01:13:08 UTC+2 schrieb Andrei Tokar: > > It depends what do you mean by "executing huge number of select > statements". MVStore is somewhat slower than older PageStore > (MV_STORE=FALSE) in a single-threaded scenario, but with latest changes > (post 1.4.97) that gap is down to about 20-40%. But multi-threaded scenario > is really where MVStore will shine (again in post 1.4.97). Try to build > from source and see for yourself. Optimization of MVStore is not just on > the TODO list for next release, many are out there already. > -- 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.
