[MUD-Dev] Database vs. Disk

Adam Dray adam at legendary.org
Sat May 17 18:36:55 CEST 2003

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 at kanga.nu

More information about the mud-dev-archive mailing list