[Home] [Groups] - Message: [Prev in Group] [Next in Group]

nu.kanga.list.mud-dev

27358: Re: [MUD-Dev] Database vs. Disk

[Full Header] [Plain Text]
From: Adam Dray <adam@legendary.org>
Newsgroups: nu.kanga.list.mud-dev
Date: Sat, 17 May 2003 18:36:55 -0400 (EDT)
References: [1]
Organization: Kanga.Nu
On Sat, 17 May 2003, Tom wrote:

> I know it depends on many factors, let's assume a mySQL database
> without alot of bells and whistles on the DB end (stored
> procedures, etc.).

I would recommend avoiding SQL altogether and just write a custom
database optimized for single-object retrieval.  RDBMSes seem
optimized for finding a lot of data fairly quickly, not finding a
specific object very quickly.  Typical queries for a mud will be of
the latter kind.

Adam Dray


_______________________________________________
MUD-Dev mailing list
MUD-Dev@kanga.nu
https://www.kanga.nu/lists/listinfo/mud-dev