Hi, Thanks for your answer, here it is :
---- Statistics ---------- -- page count: 41904 free: 15126 -- page data head: 8725613 empty: 18659533 rows: 27060934 -- page count type: 0 36% count: 15126 -- page count type: 1 63% count: 26585 -- page count type: 2 0% count: 187 -- page count type: 6 0% count: 3 Maybe there is a link with the way I update the database. So here is the context : -I use the 1.3.148 version of H2, I have done the test with the latest stable version (1.2.147) and the results are roughly the same. -My database is embedded in a file -My program only use one connection during the whole process of writing. -I only use prepared statements to fill in the database. I have done several tests with batch updates varying the number of statements per batch from hundreds to thousands and it appears that the fastest way to fill in the database is not to use batch update, that's what I did. By the way the size of the database is always the same even with batch updates. Thanks in advance for your help. Best regards On Dec 20, 9:26 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > > The size of this file is around 25Mb and the resulting H2 database is > > around 80Mb. > > The database file usually needs more space than a text file, mainly > because a database uses b-trees that are on average only 50% full (to > allow fast inserts and updates). Also, you may have secondary indexes. > But the ratio 25 MB to 80 MB is quite big. Could you run the Recover > tool and post the statistics part (at the end of the .sql file)? > > Regards, > Thomas -- 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.
