Hi, What think you of using only 2 files, one for all normal columns and otherspecialized for long data types(LOBS). Something similar to "Regular Tablespaces" and "Large Tablespaces" in oldies DB2s.
That way you have both goodies, only two files and one of them specialized fileStore to contain all lobs columns ( used only if lobs are referenced) , that can facilitate locator's implementation too. regards, Dario. El 17/12/10 09:49, Thotheolh escribió: > 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. -- 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.
