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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
