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/[email protected]/
>> 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/[email protected]/
> 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/[email protected]/
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.
