Hi, I have a Java application that uses h2 database (version 1.4.192). I noticed that the .db file grows bigger and bigger over time, although the number of records are stable. The application inserts and updates new records from time to time; it also deletes old records. Therefore the total number of records is not growing. With about 40,000 records, I noticed the file size has grown from 9MB to over 50MB in a day or two. When I added the option "DEFRAG_ALWAYS=TRUE" to h2 url, then the size could go back to 9MB after I stopped the java application. Is there something I can do to automatically "defrag" without restarting the application? Should I update h2 version?
Thank you very much for the help! Qingyu (Helen) Zhang -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
