That's a good idea using one for normal tables and the other for huge storages. It did propose to split the huge storage to CLOBS and BLOBS so that there wouldn't be a need to mix binary and character based storage and make it hard for locators to locate resources.
Regards, Thotheolh. On Dec 18, 3:49 am, Dario Fassi <[email protected]> wrote: > 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. -- 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.
