| Subject | TIBOQuery: Are Blob contents in a dataset automatically loaded into memory? |
|---|---|
| Author | mitch_landor |
| Post date | 2007-10-29T12:35:36Z |
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?
Mitch
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?
Mitch