Hi Thomas,
Do comparison operations load the entire object into memory or
compare on a piecemeal fashion? Whenever someone uses BLOB I assume the
worse-case scenario of very large objects, on the order of MBs or GBs of
data per row.
Thanks,
Gili
On 07/04/2011 12:55 PM, Thomas Mueller wrote:
Hi,
H2 still does create temporary files for BLOBs / CLOBs in the server
mode, so performance isn't that great in all cases.
But BLOBs and CLOBs are never read fully in memory, unless there is a
bug, or if you call a function that explicitly loads the object. So
for example comparison operations including (X = Y) and (X LIKE Y)
will try to load the object in memory (on the server side).
Regards,
Thomas
--
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.
