Hi, I am trying to use H2 as a in-memory cache in my middleware. I have 3 flat tables. No constraints and indexes on each table on the primary key.
As a performance test, I loaded about 125K rows in the tables. The memory went up 1 GB. After that I ran a TRUNCATE TABLE command on each of the tables. I wanted to see if the memory footprint of the server process to come down. However it still remained the same. I added about half the old data. The memory increased by another expected 500MB close to 1.5GB from the intial memory footprint. Could you please let me know what I need to do in addition to TRUNCATE TABLE to reclaim memory from H2 database without restarting the server process. Thank you. Regards, iceman. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
