05-09-2006, 01:11 PM
Ditto ditto ditto.
Oh, and what they said above. References.
Most databases do an incredibly poor job of storing and retrieving variably-sized entities of any type, let alone binary large objects (BLOBs) like images, audio or video.
Those that do a decent job store/use references to specify where the object data can be found. The references are of a known size and can be allocated/sorted/stored easily.
The downside is that the data object can be (re)moved without the reference being removed or updated.
TANSTAAFL
Oh, and what they said above. References.
Most databases do an incredibly poor job of storing and retrieving variably-sized entities of any type, let alone binary large objects (BLOBs) like images, audio or video.
Those that do a decent job store/use references to specify where the object data can be found. The references are of a known size and can be allocated/sorted/stored easily.
The downside is that the data object can be (re)moved without the reference being removed or updated.
TANSTAAFL