://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
Does anyone have any experience storing images in SQL 7.0,
and retrieving them in CF?
Its far faster, easier and a lot less messy to store the
images's name and then dynamically construct the path
information.
I've asked this question before also. And got similar
responses as
One of the "smaller" issues is backing up..
if the images are stored in the database, they will also be backed up
every time you back up the database. If you have a lot of graphics, it
will greatly increase the costs (time, media and slowing down the website)
to do your daily
Rick,
Others have dealt with speed and storage issues regarding images and
databases. Here's how I handle things. Rather than calling a BLOB
object. What happens when your client wants to change a significant
proportion of the images - its much easier copying the new images to the
appropriate
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)
: Monday, January 08, 2001 4:27 PM
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
EBS
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
January 08, 2001 5: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 fo
Quoting Rick Lamb [EMAIL PROTECTED]:
Could you guys give me suggestions for the best way to store images in
a
database.
I usually just store the image name in the database. If necessary you could also
store the path to the image in the database. Other than that I don't know what
you need
hit,
and is possible, seems to be a much cleaner solution.
Rick
-Original Message-
From: Jennifer Larkin [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 29, 2000 5:07 PM
To: CF-Talk
Subject: Re: storing images in SQL database
Quoting Rick Lamb [EMAIL PROTECTED]:
Could you guys give
in the database as binary. If it wasn't much of a performance hit,
and is possible, seems to be a much cleaner solution.
Rick
-Original Message-
From: Jennifer Larkin [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 29, 2000 5:07 PM
To: CF-Talk
Subject: Re: storing images in SQL database
Quoting
if the purpose of storing them in the db is for "protection" or regulating
access to specific images, a better way is to store the images in a private
directory and use cfcontent shoot them out. of course, for this you'll
need a gateway page like "getimage.cfm" and usually wind up passing a
12 matches
Mail list logo