Hi, > h2 and have noticed that for what should be a mid-sized > application (100,000 or so entries) has generated 26,000 files
Most likely the problem is that your are using CLOB or BLOB columns - see http://www.h2database.com/html/datatypes.html#blobtype By default columns of those types are stored as separate files if they contain more than 1024 bytes. You can change this limit, see also http://www.h2database.com/html/grammar.html#setmaxlengthinplacelob > Perhaps, database engines are sufficiently complex that taking > the time to READ ALL the documentation, which in H2's case is > quite small, (say compared to PostgreSQL) you would easily > have found the DataBase File Layout table. People don't usually read all documentation. However, there is a search function in the documentation and on the web site that should help finding the relevant information. > bloat in the data file (currently at 224 Mb) Yes, H2 does use quite a lot of disk space unfortunately. I am working on a better solution now. This should also reduce the number of files by the way - my current idea is to have exactly one non-temporary file per database. 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 -~----------~----~----~----~------~----~------~--~---
