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.