My solution is importing data to h2 normally, and the *mv.db file size increased dramatically, and then jdbc/execute! a sql to create a empty table with db url option ";DEFRAG_ALWAYS=TRUE", the size of db file dropped dramatically. the reason to do this is if jdbc/insert-multi! with ";DEFRAG_ALWAYS=TRUE", the efficiency of importing dropped. At last jdbc/query with ";DEFRAG_ALWAYS=FALSE;ACCESS_MODE_DATA=r". the size didn't change anymore. Is there anyone can tell me the reason about h2 db file frage? why is it so big? Is it a special attribute of h2 or is common for embedded database or database?
-- 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.
