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 memory successfully. I did load tests , http tests with wrk tool, JMH tools with success.But when I took this to production server where I am having 6lc records in inventory on RDS. H2 inmemory is not able to load inventory, build H2 in mem .
If I use MVStore=false in my connection url for in memory h2 db, I am able to build the db in mem successfully, but soon starts giving heapspace and thread blocking issues. Also if I run it on File server mode it loads quickly but I want to run it in memory. This is my connection url : quarkus.datasource.jdbc.url=jdbc:h2:mem:INVDB;MODE=MYSQL;IGNORECASE=TRUE;CACHE_SIZE=6368709;MV_STORE=false;RETENTION_TIME=1000 please suggest how to load in memory this database successfully with no heap space issues. With regards, Tapan Aggarwal -- 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 discussion on the web visit https://groups.google.com/d/msgid/h2-database/38036a3f-940b-43d6-9d7c-d4e61cc4078cn%40googlegroups.com.