[MUD-Dev] Re: Databases: was Re: skill system

[J C Lawrence <claw#under,engr.sgi.com>]

On Tue, 16 Jun 1998 10:46:20 -0400 (EDT) 
s001gmu <s001gmu#nova,wright.edu> wrote:

> We're working on using either CQL++ (if they will ever get back to
> me!  grumble) or mSQL for our DB back end.  

I haven't confirmed this, but I've read several reports that both
MySQL and mSQL both have performance/scalability problems with large
databases.  You may want to investigate this area.

> Did they write anything about the MUSH DB expiriement, btw?  I'd
> love to get my hands on any documents they produced.

I've only read references to it.  I suspect that all the real
discussion occurred on Marcus Ranum's Wizard list, which was in many
ways the equivalent of MUD-Dev 10 years ago (and sadly seems to be
last as far as archives are concerned).

> JC uses an OO DB, but not a pre-packaged one, if I recall.  There
> has been a lot of discussion about OO DBs in the past, and some
> minor discussion about RDBs.

My current implementation uses a linear TDBM descendant.  In moving
towards more of a persistent store model I've gone towards Persist++
and Texas munged into my prior TDBM-like model (and have ended up with
a right load of bollocks, if a set of interesting proof cases).  

-- 
J C Lawrence                               Internet: claw#null,net
(Contractor)                               Internet: coder#ibm,net
---------(*)                     Internet: claw#under,engr.sgi.com
...Honourary Member of Clan McFud -- Teamer's Avenging Monolith...