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)!
Author: Nicolai Wadstr|m
Date: Tue, 14 Apr 1992 01:25
Date: Tue, 14 Apr 1992 01:25
25 lines
1616 bytes
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