> Are you saying that if you take the broader perspective, that using a
> db instead of files is the most efficient way to serve content, any
> content?
I don't believe db based solution is the way to go to server every type of
content. In my case, this is true. The site pushes out text content in the
averge range of 30KB per pop. Before, I used CF to read in files to a
variable and the outputting that to the browser so basically I had CF as the
bridge between the browser and file. So instead of having CF accessing the
file system i/o directly I have asked CF to access the db instead. I do not
have any performance numbers for you but the improvement is significant but
this will only help you if you plan to do tons and tons of file reads.
So basically the I have changes the previous path of :
Browser << Web Server << ColdFusion << File System
to
Browser << Web Server << ColdFusion << Database
If you are serving images then the fastest way to do it is stil lthe old
fashioned way of :
Browser << Web Server << File System
All the new webservers are have their own caching mechanism you don't have
the overhead of coldfusion,asp, or anyother tool pushing the content fromt
he database to the webserver. In my experience, and since I have to do
everything through ColdFusion, ColdFusion << SQL is more efficient than
ColdFusion << File System in the long haul. However If you can skip
coldfusion, skip it. No matter how fast your machine is, having the
webserver caching large files is gotta to be faster than cf or sql
caching/pushing out large files.
Xing
> If this logic is valid, wouldn't the same be true for serving images,
> pdf files, sound files, etc?
>
> From an application design standpoint, it is a lot cleaner to store
> everything in the db because:
>
> you get all the good things & discipline of a db
>
> you avoid all the problems screwing around with the OS's file system
>
> So, in an ideal world, all content would be in the database.
>
> For example, I have heard thgat storing images (or any blobs) in a db
> will bring it to its knees.
>
> I have experimented a little with smaller images and not experienced
> any problems other than CF 4.0's inability to manipulate binary data.
> I use ASP to binary read an image, and store it in the db (never
> storing/renaming/deleting anything in the file system). Then a small
> ASP program is used to retrieve & serve the images when requested in
> an <img> tag.
>
> Are you saying that if you take the broader perspective, that using a
> db instead of files is the most efficient way to serve content, any
> content?
>
> Stands to reason that saving/retrieving a few sectors in a db is a
> lot more efficient than going through all the overhead of
> allocating/opening a file, etc, then saving/retrieving a few sectors
> in the file
>
> Hmmm... this is very important.
>
> Got any performance stats?
>
> I'll looked at the fanfiction site... interesting
>
> Dick
>
>
>
> At 2:17 AM +0000 9/21/09, Xing Li wrote:
>> Steve Katz,
>>
>> You might want to check out www.fanfiction.net for pointers.
>> Archiving/Publishing of stories from lesser known authors is exactly what we
>> do there. The stories are uploaded by the user and the content, no matter
>> how large, is stored into MS SQL 2000b2 database. You can save and serve the
>> stories out of physical files but I have found out that it is much more
>> efficient to serve them straight from the db. Reading straight from a file
>> and pushing that file to the web is general faster than a db solution on a
>> small scale. However, once you have tons of traffic and thus tons of file
>> i/o calls, the cpu spikes like crazy and everything slows down. The
>> database, although slower under low load, is much more optimized for heavy
>> constant reads and not to mention a internal caching mechanism.
>>
>> Xing
>>
>> www.fanfiction.net
>>
>>
>>>
>>> ----- Original Message -----
>>> From: Steven Katz <[EMAIL PROTECTED]>
>>> To: <[EMAIL PROTECTED]>
>>> Sent: Thursday, September 14, 2000 4:00 PM
>>> Subject: Upload and retrieval of stories?
>>>
>>>
>>>> Hi all,
>>>>
>>>> I'm developing a site that will feature short- to medium-length
>>>> stories from lesser-known authors. I have designed a page that will
>>>> serve as a template, into which I will insert the material contributed
>>>> from the authors. I would rather that this process of inserting
>>>> content not be a manual one. In fact, I would like the programmatic
>>>> solution to include a web-based administrative interface. Normally,
>>>> this might consist of some forms and CF or PHP, allowing the user to
>>>> upload content to a database, where the material could then also be
>>>> made available to the templates for the dynamic creation of pages.
>>>> However, form fields seem to have a rather small character limit,
>>>> preventing one from simply pasting an entire story into them. This
>>>> isn't really what I want to do anyway. Has anyone devised a good
>>>> process for accomplishing something similar? Perhaps there's no reason
>>>> to store this material in a database, anyway? I'd be very interested
>>>> to hear your suggestions.
>>>>
>>>> Thanks,
>>>> Steven
>>>>
>>>> --------------------------------------------------------------------------
>>> ----
>>>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>>>> To Unsubscribe visit
>>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>>> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>>> the body.
>>>>
>>>
>>>
>>> ----------------------------------------------------------------------
>>> --------
>>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>>> To Unsubscribe visit
>>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>>> send a message to [EMAIL PROTECTED] with
>>> 'unsubscribe' in the
>>> body.
>>
>>
----------------------------------------------------------------------------
->> -
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> To Unsubscribe visit
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>> k or send a message to [EMAIL PROTECTED] with
>> 'unsubscribe' in the body.
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
> body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
