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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
