🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.os.os2.programmer
Article #695

Database design problem (under OS/2)!

#695
From: 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
Technical Details
Message-ID: <1224@lysator.liu.se>
Path: arc1-ca.pugleaf.net!sparky!uunet!think.com!mips!swrinde!gatech!bloom-beacon!eru.mt.luth.se!lunic!sunic!liuida!isy!lysator.liu.se!nicolai

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!think.com!mips!swrinde!gatech!bloom-beacon!eru.mt.luth.se!lunic!sunic!liuida!isy!lysator.liu.se!nicolai
From: nicolai@lysator.liu.se (Nicolai Wadstr|m)
Newsgroups: comp.os.os2.programmer
Subject: Database design problem (under OS/2)!
Message-ID: <1224@lysator.liu.se>
Date: 14 Apr 92 01:25:07 GMT
Sender: news@isy.liu.se (Lord of the News)
Organization: Lysator Computer Club, Linkoping University, Sweden
Lines: 25