On Friday, April 26, 2019 at 4:28:00 PM UTC+2, Evgenij Ryazanov wrote: > > Hello. > > CTEs are experimental in H2 and have known bugs, recent versions contain > some fixes, so this performance drop may be somehow related with them. But > older versions of H2 do not support CTEs at all, so I don't understand how > you can test a feature that does not exist. > > We still need a complete standalone test case for your issue. >
CTE was working with v1.2.x from what I recall and tested. I grant that CTE is overkill, but I needed the test to be compute intensive, to test the engine itself. What I re-created just now is purely based on DDL: DROP ALL OBJECTS; CREATE TABLE TAXNUM ( TSN CHAR(6) PRIMARY KEY NOT NULL, NAME VARCHAR(255) NOT NULL, "TYPE" VARCHAR(255) NOT NULL, PARENT VARCHAR(255)); I added some pauses ranging from 50ms to 100ms (we call them thinktime in performance testing) and I did only 4 versions, with similar load as described in my earlier email. Here's the result: 1.4.197 is still slower. 1.4.198 went into errors as I believe the thinktimes are not long enough. I'll fix that. [image: h2c.png] -- 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.
