I can say that the approach with VARCHARs works ok in my case after several months of test/production usage. I'm using up to 10K length VARCHARs.
On Tuesday, March 5, 2013 2:18:21 AM UTC+2, Kartweel wrote: > > It depends on your use case I think. I recently had 10MB objects reading > into memory... but it wasn't very optimal and I did get OOM errors :). > I'm sure 1024 characters would be fine ;). It's probably faster than > with CLOBS as they'll be inline so one less pointer to follow. > > I'd just test it and see how you go. I think CLOB will behave the same > as BLOB. But I guess you have to try it to make sure. > > > > Integer.MAXVALUE > > I'll try to use VARCHAR(1024); but > > > > > CLOB > > > should be used for documents and texts with arbitrary size such as XML > > > or HTML documents, text files, or memo fields of unlimited size. > > > VARCHAR should be used for text with relatively short average size > > > (for example shorter than 200 characters) > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
