Re: [h2] why insert many record to in-memory database is same speed as embedded-mode

Apparently, you assumption about "In-mem should be much faster" is not correct. It just makes me wonder, what exactly is the problem at hand? Is that the disk-based database is too fast? Or there is an expectation of some "ludicrous speed"

Re: [h2] why insert many record to in-memory database is same speed as embedded-mode

no, my program use 20 mins keep inserting to H2 (embed + in memory), both speed become stable and nearly the same. On Tuesday 9 January 2024 at 01:30:44 UTC+8 Andreas Reichel wrote: > Because its cached and data are written to disk only eventually when the > cache is full? > > On Mon, 2024-01-0