Hi, Currently the database files never shrink. Empty space is re-used, but the .data.db and .index.db files don't get smaller. I am working on a solution for that. The plan is: one file per database, and automatically shrink the file. There is a disadvantage however: if you delete large objects (CLOB/BLOB), the disk space would not be freed immediately (like now).
Regards, Thomas On Mon, Dec 1, 2008 at 5:48 PM, edwardsk <[EMAIL PROTECTED]> wrote: > > We have a simple db schema consisting of only two tables and a few > indexes in addition to the PK indexes. > > The DB tables are truncated daily if not more frequently, but while > the db is in use, we insert data every second... > > When the database is truncated, should the .data and .index files > physical file size shrink? > Ours appear not to "shrink" as I would guess they would... is this > expected functionality? > > Thanks > Kevin > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
