OK, now as I read I see that *.lob.db are not temporary, so I'll keep them. :o) I am to assume that every text field in the entire database is stored as an individual file? Since I will probably top out at half a million of these, in that case, should I start getting worried? Has anyone tested this database with that many? Also, there is enormous bloat then in the data file (currently at 224 Mb). What is in there that occupies so much space? As I say I have entered less than 50 mb and most of that is accounted for in the many lob.db files.
This is a project where I take an email archiving system (running under an old version of DB2) and import it into a newer, hopefully more portable database. This project is barely 10% imported and at this rate the size of it will be astronomical. The old system is running about 500 Mb, so it seems that using h2 causes a 10 fold increase storage space. Is this normal? jj On Dec 15, 12:41 pm, jjg <[email protected]> wrote: > One quick question: if I wanted to do some manual cleanup, what can I > delete without damaging my data? Anything of the form *.lob.db? > > Thanks! > > On Dec 15, 12:04 pm, jjg <[email protected]> wrote: > > > Hi, > > > I am using h2 and have noticed that for what should be a mid-sized > > application (100,000 or so entries) has generated 26,000 files (!!!) > > and takes up 500+ mb. I estimated that I have less than 50 Mb in it, > > really. > > > What gives? I read that earlier versions of h2 (before 1.1.102) do not > > necessarily remove temp files, but upgrading did not seem to affect > > this. > > > Perhaps I need to compact the database? Again, online searches tell me > > to run a script, but where in the distro is this? > > > Thanks in Advance > > > jj --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
