Subject Re: [IBO] TIBOQuery: Are Blob contents in a dataset automatically loaded into memory?
Author Thomas Steinmaurer
> If I have a query which includes a blob column, do the contents of the
> blob column get loaded into memory or is it just some sort of pointer?
> In other words if I have many rows and large blobs, will I swamp my
> ram when I execute the query? Is it better to have the blobs in a
> referenced table and only load one when needed?

AFAIR, IBObjects will only load the content of a BLOB if you ask for it,
e.g. when using a image component, which displays the image
automatically, ...

Whether the BLOB content gets loaded or not, can be easily checked via
the TIB_MonitorDialog. In this dialog, click the Blob option and watch
out if the SEGMENT SIZE is larger than a value of ~ 10 (so, not the BLOB
ID = pointer only)

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions