Thanks very much for the information. On Fri, Dec 5, 2008 at 8:39 AM, Thomas Mueller <[EMAIL PROTECTED] > wrote:
> > 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 -~----------~----~----~----~------~----~------~--~---
