[Home] [Groups] - Message: [Prev in Group] [Next in Group]
4978: Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??
[Full Header] [Plain Text]
From: J C Lawrence <claw@under.engr.sgi.com>
Newsgroups: nu.kanga.list.mud-dev
Date: Mon, 23 Mar 1998 12:48:36 -0800
References: [1]
Organization: Kanga.Nu
On Sun, 22 Mar 1998 12:17:33 PST8PDT
Ben Greear<greear@cyberhighway.net> wrote:
> On Sun, 22 Mar 1998, Greg Munt wrote:
>> I'm not sure of the advantages of binary flat files over ASCII
>> ones. I would certainly advise the use of a cache,
>> however. (Something which that TinyMUD never used.)
> I'm definaly not going to write a custom caching mechanism...much
> easier and probably better to use the OS.
I use a fairly simple extension of an LRU cache for my DB (now
persistant store). Turning off the DB cache degrades performance to
less than 1/8th the transaction rate I can support with the cache.
There are reasons procesors have pipeline look-ahead, instruction
caches, databases have record and object caches, filesystems have
read/write caches, hard drives have caches on the drive itself, SCSI
adaptors have caches on the card, etc etc etc (between a single
fwrite() call and the disk platter there are 5 caches in my system --
all of them doing their job in increasing disk read/write performance)
--
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...