Hi, I moved away from memory database to pure embedded database, using pagestore format. I stick to CTE, as it was supported for the releases used inside comparison scope, and CTE is slowish to allow comparison of graphs. DDL and DDQ were too fast for the graphs to be differentiated.
I've posted my JMeter code at github: https://github.com/cmichon/h2lander "In the end, there can be only one H2 release" :-D If you wish to reproduce this, you'll need JMeter 5.1.1 with following plugins: - jp@gc - Response Times Percentiles - jp@gc - Active Threads Over Time In order to run this load test, you need to initialize a local db first, using the init.sql file provided. You can use the cte.sql in order to build a standalone java testcase. I preferred using JMeter in order to add some concurrency, allowing to stress H2 enough to have decent graphs. You can find the jtl results and HTML reports as 7-zip archives on github. Jtl file can be reloaded inside the listeners of JMeter. If you do not know how JMeter works, either use the HTML report or look at the picture below. Results are unchanged: H2-1.4.196 was on par with H2-1.2 and H2-1.3, but last 3 releases of H2 have worse timings, especially 1.4.197. Here's the graph: I keep the TCP analysis aside for now. Rgds Christian On Wednesday, May 1, 2019 at 9:19:20 AM UTC+2, Christian MICHON wrote: > > Yes in memory only for now. > > I can move it to embedded files and tcp as well. > > What I saw is a sudden drop of performance between 196 and 197. That drop > was halved and partially recovered in 198 and 199. > > But it's still, for that particular use case (CTE), too slow compared to > older versions. > > I managed my refactoring in JMeter to remove jdbc connection pool, as this > was the issue between sessions and DDL use case. I also reverted to a CTE > use case. > > I'll share this on github after my analysis with embedded and tcp. For tcp > I'll need to use a separate machine. > > Rgds > Christian > > -- 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.
