Go back to previous page
Forum URL: http://www.eyrie-productions.com/Forum/dcboard.cgi
Forum Name: Introductions
Topic ID: 1
Message ID: 30
#30, RE: Separate threads...
Posted by megazone on May-03-01 at 05:20 PM
In response to message #27
>>Unfortunately messier than that - posts are stored in multiple ways:
>>- a flat HTML file of the entire thread (what you see with View All)
>>- a flat .txt file with all the posts in it in a delimited format
>>- a database.txt file stores the list of threads for the forum and
>>associated data in a delimited format
>
>hideous hideous hideous. /me lost 2d6 SAN (I rolled a 10)
>when looking at the storage structure for articles.

The flat HTML file is cool - it cuts server load, when you 'view all' you are hitting a link to a static HTML document. That's fine.

The large flatfile on the other hand... Yeah, I'm trying to encourage the next major revision move to individual files for each post. If I knew more, or rather, anything really about USEnet post formats on an newsserver I'd probably push for something closer to that.

The database.txt file I have no problem with - it improves performance by not having to parse all the posts for the relevant info.

Of course, the next major rev is supposed to support an SQL DB backend anyway, which is the better choice overall. (Probably MySQL - maybe others.) But a lot of users don't have access to a DB and need the flat file support.

If you have suggestions for article storage, please share them.

-MegaZone, megazone@megazone.org
Personal Homepage http://www.megazone.org/
Eyrie Productions FanFic http://www.eyrie-productions.com/