I am using 1.0.72 version of H2 and the database is in-memory. mem:cachedb;DB_CLOSE_DELAY=-1
On Feb 4, 3:10 pm, iceman <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
