Do all transactional protections (including those provided by two-phase commit protocol) apply to BLOBs or are they second-class citizens?
On Wednesday, September 2, 2020 at 4:34:41 AM UTC+2 Evgenij Ryazanov wrote: > Yes, LOB values are stored separately in H2 and in many other DBMS, unlike > other values. > > When you read a row, all non-LOB values are read, presence of some large > value may slow down the whole operation even when it doesn't need to read > them. Presence of large LOB value is cheap here, because only its > descriptor will be read, but not the actual value. On the other hand, when > you need to read a LOB value, a separate read operation is required. > > Small LOB values (up to 256 bytes by default, the documentation is > outdated) in H2 are stored directly in a row like all other values. You can > set MAX_LENGTH_INPLACE_LOB to a larger value if you wish. > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/7edf9f50-1a4f-4894-820a-924868eecc92n%40googlegroups.com.
