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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
