Hi, Is there something I miss with the statistics ? I'm not sure to understand exactly what those statistics mean and consequently if there is a way to solve my problem.
Thanks in advance for your help. Best regards On Dec 21 2010, 11:59 am, Xanadu <[email protected]> wrote: > 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.
