Highlighted

Question about using images stored in a database

LEGEND ,
Jun 09, 2016

Copy link to clipboard

Copied

Hello, all,

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.

V/r,

^_^

Views

230

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Question about using images stored in a database

LEGEND ,
Jun 09, 2016

Copy link to clipboard

Copied

Hello, all,

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.

V/r,

^_^

Views

231

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 09, 2016 0

Have something to add?

Join the conversation