On several of our primary projects, we are storing non-common images (ie, images for articles; not formatting or background images) in an Oracle 11g database, and using queries to retrieve and display them. For the most part, this is working quite well.
However, an issue has come up which has caused our PM to question: When an image is pulled from an Oracle db via ColdFusion Server, is the image downloaded in a single reference? Or, does either Oracle or CF Server split the BLOB into chunks, causing more than one reference to the image?
In CFAdmin, the BLOB is set for 64000. Is this a buffer size value? It's the default when the DSN is created in CFAdmin.
Have something to add?