M
Mike Fechner
Guest
Didn't find a clear hint for this in the docs... When is a BLOB actually read from the database? I made some tests (admitting I am not a DB expert) but it seems that a BLOB is only read from disk when it's really needed. A unique FIND on the record that contains the BLOB (54 MB) causes only 1 DB read. A LENGTH (BLOB field) causes no DB reads. COPY-LOB of the LOB field causes a bunch of DB reads (13.000). I ran those tests in a DB that did only contain a single DB table with only a single record.
Continue reading...
Continue reading...