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]
