Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Binary BLOB storage 1
- Thread starter doloto
- Start date
-
1
- #2
MartijnTonies
Programmer
Hi,
All data is stored inside the datafile (database). In each row with a BLOB value, a pointer to the actual blob is stored. If you retrieve the BLOB (via components or whatever), InterBase fetches the blob stream by following the pointer.
The pointer means that a blob is not stored "inline" - at the same data-page as the rest of the row(s). So you can easily have a lot of blobs per table and as long as you don't retrieve them, it won't harm speed fetching data from disk...
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
All data is stored inside the datafile (database). In each row with a BLOB value, a pointer to the actual blob is stored. If you retrieve the BLOB (via components or whatever), InterBase fetches the blob stream by following the pointer.
The pointer means that a blob is not stored "inline" - at the same data-page as the rest of the row(s). So you can easily have a lot of blobs per table and as long as you don't retrieve them, it won't harm speed fetching data from disk...
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
- Status