[h2] Re: compactRewriteFully safety with DB writes

2021-07-24 Thread Matthew Phillips
Sorry to keep replying to myself, but another question. After trialling the latest H2 (1.4.200) with our existing data, I saw heap usage shoot up from 150-200MB where it hovers with 1.4.147 to 840M and rising after a fairly short run time. Now, I expect this is totally caused by my set up sinc

Re: [h2] H2 Inmemory not able to load 7lc records and giving heapspace issues

2021-07-24 Thread Noel Grandin
try using nioMemFS to store the data on the native heap -- 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 view this dis

Re: [h2] Autonomous commit - commit single savepoint or transaction

2021-07-24 Thread Noel Grandin
you're going to need to use two connections to achieve that -- 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 view this

[h2] H2 Inmemory not able to load 7lc records and giving heapspace issues

2021-07-24 Thread Tapan Aggarwal
Hi , I have an Inventory application created in Quarkus framework with AWS RDS Db. I configured H2 inmemory db with the application for faster performance. on my local inventory table in RDS Db was having 1 lc records so h2 inmemory while startup of application was building this table in memor