Rick,
Utilizing CF to simply identify the location of the image is simpler for
several reasons. I consider myself much junior to the great minds on this
forum but I will humbly offer my experience.
Simply put, speed and flexibility are your bonus payoffs. Key points for
flexibility are:
- you can identify the base image path in your application.cfm and simply
reference the image name in the database in your code/query. This is a
powerful key when you get a large project with thousands of images and you
can identify separate image locations by department, location, branch etcetc
to suit the business needs.
- We have also found great flexibility in creating client maintained admin
interfaces that allow them to dynamically build their own catalogs as they
get new products through an interface that they use to add items in the
database and upload new images to the image location for their department.
- Speed, the biggest bonus. A simple query with a result of less than 30k in
data (including the image reference) is loads better than the same query
returning effectively the same data at 80+kb. Multiply that times thousands
of users.. etc
Case in point? http://www.edwardsluggage.com
I hope my 2cents helps.
Tony Gruen
Development/SFNetworks
[EMAIL PROTECTED]
-----Original Message-----
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 2:40 PM
To: CF-Talk
Subject: RE: Storing images in SQL
Larry,
I've asked this question before also. And got similar responses as yours
which is appreciated. But is there any way you could tell us (a number of
people have asked this question) why it's slower and messier. I'm sure for
somebody that knows the details on what it takes to do this can logically
agree with you (and others who have said the same) and I too would like to
be one of those well informed people that come to the same conclusion for
the same reasons. Could you or anyone else familiar with the techniques
required for this please elaborate on this so I can say something other than
"it's a bad idea because that's what somebody said."
Thanks,
Rick
-----Original Message-----
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:28 PM
To: CF-Talk
Subject: Re: Storing images in SQL
Michael,
In a nutshell don't. Its far faster, easier and a lot less messy to
store the images's name and then dynamically construct the path
information.
regards,
larry
--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]
Chaos, panic, and disorder - my work here is done.
--
Michael Buffington wrote:
>
> Does anyone have any experience storing images in SQL 7.0, and retrieving
> them in CF?
>
> Any tips would help!
>
> Michael Buffington
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
