Yes it is possible
Some considerations:
You can store the .jpg files as files and reference them with a SQL database
pointer to the file
keeping track of 10,000 different .jpg files is messy if you store them as
files (I am told there is a 500 file per directory limit on NT)... so you
have multiple files and directories
You can store the .jpg files in the database as blob (large binary) fields
(I am told that this is inefficient)
CF 4.0 does not support manipulation of binary fields to/from a database
(4.5 apparently does)
If you are on CF 4.0 and a win OS, you can manipulate the binary
files to/from
the database with ASP
I have done limited experimentation with this ASP CF combo and it appears to
work and perform acceptably... and eliminates a lot of messy file
manipulation
All in all, i would think that the blob in the db is the lesser of two evils.
Dick
At 10:51 PM +0000 12/14/00, t nelson wrote:
>Hi all,
>
>I am wondering if this will even be possible or if I just have a pie in the
>sky dream.
>
>Here it goes:
>
>Let's say that you have an online store with a huge inventory of products,
>we're talking close to 10'000 distinct items. your site has everything we
>have come to expect from an e-store application (search features, shopping
>carts, etc..). if by some miracle i had a good quality and not too big
>(under 10k each) .jpg or .gif for each item in my inventory. would it be
>possible for me to some how link each of those pictures to its corresponding
>part in my database? this way when a customer searched for an item, a nice
>picture could come along with it.
>
>again, is this even possible, if so how?
>
>thanks in advance for your time and help,
>
>nelson
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
