🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: comp.os.os2.programmer
1 messages
1 total messages Started by Nicolai Wadstr|m Tue, 14 Apr 1992 01:25
Database design problem (under OS/2)!
#695
Author: Nicolai Wadstr|m
Date: Tue, 14 Apr 1992 01:25
25 lines
1616 bytes
I'm working on a mail handling (and BBS) system under OS/2, but
I've run into some problem in the design of the message database.
As the system will handle UUCP and USENET mail, messages can be
quite large. The best solution I've found so far, is to store
the message header in a B-TREE indexed database and the message
texts in seprate files, named after the header index number.
But this could result in that several thousand files are stored
in one directory, which probally will be quite slow (relativly) to
open (OS/2 will have to read the long directory often), but maybe
this can be speeded up by large cache size.
Message could also be stored in diffrent directories (one for each area
maybe) which would speed up directory read and file opens.
Is there any other solution?
Would greatlly appreciate any hints on this matter!


Regards,
            nicolai, nicolai@lysator.liu.se


--
Nicolai Wadstr|m                   # Internet:      nicolai@lysator.liu.se
                                   #
                                   # BBS:           +46-40-124554 (down)
                                   # Voice:         +46-40-975535
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads