Re: [h2] push the insert speed to max

Forgot one: try multi threading, e. g. populating one prepared statement while another is executed/written. Not guaranteed if this really will be faster though. On Fri, 2024-01-12 at 15:38 +0700, Andreas Reichel wrote: > Greetings. > > On Fri, 2024-01-12 at 00:17 -0800, mche...@gmail.com wrote:

Re: [h2] push the insert speed to max

Greetings. On Fri, 2024-01-12 at 00:17 -0800, mche...@gmail.com wrote: > hi. I am running AMD 3900x with 128GB ram and a nvme ssd. Now i can > insert 1xk record per seconds, which is very fast. But how can I make > is 10 times more? what hardware can do that? 1) Ensure that all Indexes and constr

[h2] push the insert speed to max

hi. I am running AMD 3900x with 128GB ram and a nvme ssd. Now i can insert 1xk record per seconds, which is very fast. But how can I make is 10 times more? what hardware can do that? thanks Peter -- You received this message because you are subscribed to the Google Groups "H2 Database" group.

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

thanks all On Wednesday 10 January 2024 at 09:38:59 UTC+8 Andrei Tokar wrote: > 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 expec