On 1/18/07, Derrick Peavy <[EMAIL PROTECTED]> wrote:
Thank you again - everyone!
I think (by virtue of forcing the question), that the answer is that what
I want to do is not really worth it or might best be done with the
keep-alive option.
The goal, again a theoretical one, is to reduce the number of http
requests as that really is the biggest bottleneck on line these days (files
needed to construct one page, images, external Jscript, Google ads, and
scripts, etc.).
An interesting article:
http://ajaxian.com/archives/yahoo-performance-engineers-discuss-what-the-8020-rule-tells-us-about-reducing-http-requests
As I have reduced my https request I have seen faster page loads via third
party testing. But at this point, I think I am as far as can be reasonably
done.
The reason I don't like the CFCONTENT option is that in fact the entire
page output does have to be sent. I cannot simply include a CFM file which
retrieves the image and puts it in the page as the rest of the page does not
process after the CFCONTENT. As for putting the entire page in the DB, no, I
think that's not appropriate.
Just thought, maybe someone had done this and that you could spit out 1.5or
4.4 k images just like data and speed things up.
I'm no reader of RPCs on HTTP or anything, but this does not sound
possible. What it sounds like you are trying to do is deliver the binary
data for a image inline with the HTML. To the best of my knowledge that
isn't a reality. For emails maybe, but not a web browser.
_____________
*Derrick Peavy*
*Sales and Web Services *
*Universal Advertising*
*Phone: 404-786-5036*
*Fax: 404-370-0470 *
http://www.universaladvertising.com
http://www.collegeadvertising.com
http://www.collegeclassifieds.com
*___________________________________*
On Jan 18, 2007, at 12:45 PM, John Mason wrote:
Yes, you only need the server to run http 1.1 which most do. Also the
browser should be able to accept that (which most do) and the browser has
to not send a close command which at times they do.
A lot of things are controlled by the user in this situation. Whether
accepting a open keep-alive http connection or http compression. Lucky a lot
of this is already taken care of from the server end. Storing the images in
the db or on the file system isn't going to change anything there and the
end client browser really for the most part doesn't care.
John
------------------------------
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] <[EMAIL PROTECTED]>] *On
Behalf Of *Fennell, Mark P.
*Sent:* Thursday, January 18, 2007 12:07 PM
*To:* discussion@acfug.org
*Subject:* RE: [ACFUG Discuss] Image from DB
Additionally, I think HTTP 1.1 allows connection keep-alives so that you
only make one http call for the entire page. Right?
mf
-----Original Message-----
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] <[EMAIL PROTECTED]>]*On
Behalf Of *John Mason
*Sent:* Thursday, January 18, 2007 12:03 PM
*To:* discussion@acfug.org
*Subject:* RE: [ACFUG Discuss] Image from DB
Don't get me wrong, I understand it's an experiement and it's fun to try.
1. You're not actually reducing your http requests. <-- My main point with
this.
3. You can save the image data in the database as a BLOB and output it
onto a page. You'll need to use cfcontent to set the precise MIME type. If
you're using IIS 6, the MIME types are much more strict than they use to be.
John
[EMAIL PROTECTED]
------------------------------
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] <[EMAIL PROTECTED]>] *On
Behalf Of *Derrick Peavy
*Sent:* Thursday, January 18, 2007 11:56 AM
*To:* discussion@acfug.org
*Subject:* Re: [ACFUG Discuss] Image from DB
Kindly, and with respect to everyone that replied:
1. As I stated, the goal is to reduce http requests, not file sizes. And
"this is an experiment," please forgive, but the "Why" of why I want to do
this is not part of the answer.
2. Don't really need a discussion about the database design or benefits of
A or B
3. Looking for an answer to the question - How to get image in DB, image
out of DB, using CF and MySQL?
Any takers for that?
_____________
*Derrick Peavy*
*Sales and Web Services *
*Universal Advertising*
*Phone: 404-786-5036*
*Fax: 404-370-0470 *
http://www.universaladvertising.com
http://www.collegeadvertising.com
http://www.collegeclassifieds.com
*___________________________________*
On Jan 18, 2007, at 10:32 AM, Teddy Payne wrote:
This seems to be asked often about images and BLOBs. I know you are
testing an idea out and maybe you can get it to work somehow, but from a
data perspective you just don't want to use a BLOB. There is only one
technique to reduce up front cost of a BLOB and that is to have a BLOB
table. The table would not be a part of the primary table, so you would not
intefere with indexing and collation. You would have a normalized table with
a foreign key that you would only use for that web service.
Now for the webservice, wouldn't you want to return the lowest common
denomenator of data? If you are returning HTML or something that needs to
reference the image, it is acceptable to have a reference with an absolute
URL back to your server. The benefit here is that the web service is
consumed quicker, but the page load would be based on the network retrieving
the data.
In addition, you would want inside of your web service a way not to
return the image that would even speed up the browsing unless the user
really wants the image.
Teddy
On 1/18/07, Fennell, Mark P. <[EMAIL PROTECTED]> wrote:
>
> I'm just curious. What are the benefits of storing the image in the db
> rather than storing the file on the filesystem and the path in the db? I
> mean, for a web page, all you need is the <img> and the path. I can
> understand how it might be useful in some VB or C or Java app where the
> client doesn't display images with such ease, but for a web app...? Thanks.
> mf
>
> -----Original Message-----
> *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of *John
> Mason
> *Sent:* Thursday, January 18, 2007 10:16 AM
> *To:* discussion@acfug.org
> *Subject:* RE: [ACFUG Discuss] Image from DB
>
> I believe there would still be three http requests here. The images
> would still be called up in the html like <img src=""> right? Sorry but in
> http that would still create seperate http requests.
> John
> [EMAIL PROTECTED]
>
> ------------------------------
> *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Derrick
> Peavy
> *Sent:* Thursday, January 18, 2007 9:35 AM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Image from DB
>
> Probably an easy problem for someone...
> I want to put two small images in my database and then output them in my
> app, so that they do not constitute additional http requests. Consider it an
> experiment - I know that it may seem a bit silly. The goal is for the entire
> page to be delivered to the browser in one http request, instead of 3 (two
> images and one cf page) without doing any Apache tinkering. I have looked
> around the net for answers and cannot seem to make this work.
>
> Database field is "imageFile" of type BLOB in MySQL 4.1.13. What is the
> proper way to insert the image?
>
> Example: INSERT into Images (imageFile) values ('#base64(image)#')
> -Or-
> Example: INSERT into Images (imageFile) values ('#image#')
>
> And then of course, how do you retrieve it? Example: SELECT imageFile
> FROM Images WHERE imageID=1
>
> <cfoutput>
> #toString(imageFile)#
> </cfoutput>
> -OR-
> <cfoutput>
> #toBinary(imageFile)#
> </cfoutput>
>
> As I say, I've not been able to make this work. If I use toString(), I
> simply get the raw data. If I use toBinary(), I get an error that the data
> cannot be converted to a string. Also, using CFCONTENT is fine to output the
> image, but then any code after that is ignored. So, short of saving the
> entire page and then outputting, it, I don't see a way to use CFCONTENT.
>
> _____________
> *Derrick Peavy*
> *Sales and Web Services *
> *Universal Advertising*
> *Phone: 404-786-5036*
> *Fax: 404-370-0470 *
> http://www.universaladvertising.com
> http://www.collegeadvertising.com
> http://www.collegeclassifieds.com
> *___________________________________*
>
>
>
>
> -------------------------------------------------------------
> To unsubscribe from this list, manage your profile @
>
http://www.acfug.org?fa=login.edituserform<http://www.acfug.org/?fa=login.edituserform>
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink <http://www.fusionlink.com/>
> -------------------------------------------------------------
>
>
> -------------------------------------------------------------
> To unsubscribe from this list, manage your profile @
>
http://www.acfug.org?fa=login.edituserform<http://www.acfug.org/?fa=login.edituserform>
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink <http://www.fusionlink.com/>
> -------------------------------------------------------------
>
--
<cf_payne />
Adobe Certified ColdFusion MX 7 Developer
Atlanta CFUG (ACFUG): http://www.acfug.org
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
