Hi, Probably a bit faster is: "jdbc:h2:mem:test;db_close_delay=10" - this is an in-memory database (faster than "memFS:", but needs more memory); but it will keep the database open (so it keeps the data) for 10 seconds after the last connection is closed.
By the way if "mem:" and "memFS:" use too much memory, yet another option is "memLZF:" which compresses the data. Regards, Thomas
