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

2024-01-08 Thread Andreas Reichel
Because its cached and data are written to disk only eventually when the cache is full? On Mon, 2024-01-08 at 09:20 -0800, mche...@gmail.com wrote: > hi. >    why insert many record to in-memory database is same speed as > embedded-mode. In-mem should be much faster, right? > > > import

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

2024-01-08 Thread mche...@gmail.com
hi. why insert many record to in-memory database is same speed as embedded-mode. In-mem should be much faster, right? import java.io.FileNotFoundException; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import

[h2] Re: is there any command line interface can interact with h2 in shell

2024-01-08 Thread mche...@gmail.com
thanks On Sunday 31 December 2023 at 14:26:03 UTC+8 Evgenij Ryazanov wrote: > Hi! > > You can use the shell tool: > https://h2database.com/html/tutorial.html#shell_tool -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this