In another discussion I have already mentioned the problem with the huge execution times: https://groups.google.com/forum/#!topic/h2-database/Fcj2EKTyb-E
Am Mittwoch, 22. August 2018 18:35:05 UTC+2 schrieb Ivaylo Dobrikov: > > 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.
