Hi Thomas. It's true that the advantages and disadvantages are as you said but would a single storage file slow down H2 engine from looking for and getting or writing data since all the clobs and blobs which can be rather huge, are bunched together with the main database too ?
> > To bundle clob and blobs into the main database files can make the > > main database file very bulky and slow down H2 significantly. > > There are many advantages to use one file, for example it prevents the > 'too many open files' problems. Also, there are many problems because > of lost / deleted files. De-duplication is easier. One disadvantage is > that the database file can't shrink quickly after deleting many LOBs. Regards, Thotheolh. -- 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.
