Over the past few years I've gradually put more and more in the database. Once some
data is in the database your options for administration, optimization, and
maintainability are just SO much better. Stick it all in the database! If your
articles are formatted with HTML, stick them in the database anyway, and use
eWebEditPro instead of a textarea for you admin editing.
At 10:29 AM 10/31/00 -0500, James Mathieson wrote:
>Zac,
>
>Though I didn't originate this, thanks for the advice. I was going to
>pose the question today regarding using text in a database versus just
>having CF include a .htm file of the text by way of referencing the file
>name in the db.
>
>If I could pose a slightly different question (I assume you're somewhat
>familiar with Access 2K), how significant is the storage overhead for a
>memo field storing text versus that text in a .htm file? Assuming the
>size of the text is roughly that of a newsletter or magazine article.
>
>For quick background, I'm working on a site which will contain feature
>articles and columns, and I want to serve up the text in the most
>efficient way I can, hence the "stick it in the db, or reference the file
>and cf_include it?" line of questioning.
>
>Cheers,
>James~
>
><snip>
>
>There really aren't a whole lot of advantages to using the file
>system as you described instead of a database. The only possible
>situation where the file system would be better is if your host
>absolutely prohibits you from using a database OR if you don't have
>MS Access, but that's fairly reasonably priced software IMHO. If you
>can afford CFServer, then MS Access should be pocket change....
>Granted, Access has a learning curve, but you should be able to pick
>up the basics in a couple of days if you don't already know how to
>use it.
>
>Negatives for using the file system include:
>* MUCH slower
>* Not scaleable
>* Much more storage required -- depending on the file
> system, each "entry" could use anywhere from
> 8-32K of storage even if the data stored is only
> one byte!
>
>In short, use a database. They're really not all that bad...
>
>Best regards,
>Zac Bedell
></snip>
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
>with 'unsubscribe' in the body to [EMAIL PROTECTED]
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938
To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
