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.
In the latest version, the statistics include the page type name. > -- page count: 41904 free: 15126 > -- page count type: 0 36% count: 15126 This means there are 15126 free pages. There should be no free pages if you have closed the database normally (that is, closing all connections, or calling 'shutdown', or stopping the application normally). Did you do that? There is one exception where not all free pages are removed: for large databases, if you delete a lot of data and then close the database - in that case not all free pages are removed immediately, it takes a few open / close cycles). There are still 26585 pages with data, and the fill factor looks normal. But the empty pages should be removed automatically. 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.
