<!-- MHonArc v2.4.4 --> <!--X-Subject: Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ?? --> <!--X-From-R13: X Q Znjerapr <pynjNhaqre.rate.ftv.pbz> --> <!--X-Date: Mon, 23 Mar 1998 20:48:42 +0000 --> <!--X-Message-Id: 199803232048.MAA42809#under,engr.sgi.com --> <!--X-Content-Type: text/plain --> <!--X-Reference: Pine.LNX.3.96.980322130619.3549D-100000#shamen,cyberhighway.net --> <!--X-Head-End--> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html> <head> <title>MUD-Dev message, Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</title> <!-- meta name="robots" content="noindex,nofollow" --> <link rev="made" href="mailto:claw#under,engr.sgi.com"> </head> <body background="/backgrounds/paperback.gif" bgcolor="#ffffff" text="#000000" link="#0000FF" alink="#FF0000" vlink="#006000"> <font size="+4" color="#804040"> <strong><em>MUD-Dev<br>mailing list archive</em></strong> </font> <br> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] <br clear=all><hr> <!--X-Body-Begin--> <!--X-User-Header--> <!--X-User-Header-End--> <!--X-TopPNI--> Date: [ <a href="msg00858.html">Previous</a> | <a href="msg00860.html">Next</a> ] Thread: [ <a href="msg00860.html">Previous</a> | <a href="msg00857.html">Next</a> ] Index: [ <A HREF="author.html#00859">Author</A> | <A HREF="#00859">Date</A> | <A HREF="thread.html#00859">Thread</A> ] <!--X-TopPNI-End--> <!--X-MsgBody--> <!--X-Subject-Header-Begin--> <H1>Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</H1> <HR> <!--X-Subject-Header-End--> <!--X-Head-of-Message--> <UL> <LI><em>To</em>: <A HREF="mailto:mud-dev#null,net">mud-dev#null,net</A></LI> <LI><em>Subject</em>: Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ?? </LI> <LI><em>From</em>: J C Lawrence <<A HREF="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</A>></LI> <LI><em>Date</em>: Mon, 23 Mar 1998 12:48:36 -0800</LI> </UL> <!--X-Head-of-Message-End--> <!--X-Head-Body-Sep-Begin--> <HR> <!--X-Head-Body-Sep-End--> <!--X-Body-of-Message--> <PRE> 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... </PRE> <!--X-Body-of-Message-End--> <!--X-MsgBody-End--> <!--X-Follow-Ups--> <HR> <!--X-Follow-Ups-End--> <!--X-References--> <UL><LI><STRONG>References</STRONG>: <UL> <LI><STRONG><A NAME="00828" HREF="msg00828.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> <UL><LI><EM>From:</EM> Ben Greear <greear#cyberhighway,net></LI></UL></LI> </UL></LI></UL> <!--X-References-End--> <!--X-BotPNI--> <UL> <LI>Prev by Date: <STRONG><A HREF="msg00858.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> </LI> <LI>Next by Date: <STRONG><A HREF="msg00860.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> </LI> <LI>Prev by thread: <STRONG><A HREF="msg00860.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> </LI> <LI>Next by thread: <STRONG><A HREF="msg00857.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> </LI> <LI>Index(es): <UL> <LI><A HREF="index.html#00859"><STRONG>Date</STRONG></A></LI> <LI><A HREF="thread.html#00859"><STRONG>Thread</STRONG></A></LI> </UL> </LI> </UL> <!--X-BotPNI-End--> <!--X-User-Footer--> <!--X-User-Footer-End--> <ul><li>Thread context: <BLOCKQUOTE><UL> <LI><STRONG>Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</STRONG>, <EM>(continued)</EM> <ul compact> <LI><strong><A NAME="00818" HREF="msg00818.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, Greg Munt <a href="mailto:greg#uni-corn,demon.co.uk">greg#uni-corn,demon.co.uk</a>, Sun 22 Mar 1998, 17:36 GMT <UL> <LI><strong><A NAME="00828" HREF="msg00828.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, Ben Greear <a href="mailto:greear#cyberhighway,net">greear#cyberhighway,net</a>, Sun 22 Mar 1998, 20:15 GMT <UL> <LI><strong><A NAME="00831" HREF="msg00831.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Sun 22 Mar 1998, 21:27 GMT <UL> <LI><strong><A NAME="00860" HREF="msg00860.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Mon 23 Mar 1998, 20:50 GMT </LI> </UL> </LI> <LI><strong><A NAME="00859" HREF="msg00859.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Mon 23 Mar 1998, 20:48 GMT </LI> </UL> </LI> </UL> </LI> <LI><strong><A NAME="00857" HREF="msg00857.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Mon 23 Mar 1998, 20:41 GMT </LI> </ul> </LI> <LI><strong><A NAME="00809" HREF="msg00809.html">Re: [MUD-Dev] Parlez vous NPC?</A></strong>, Chris Gray <a href="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA">cg#ami-cg,GraySage.Edmonton.AB.CA</a>, Sat 21 Mar 1998, 18:10 GMT <UL> <LI><strong><A NAME="00813" HREF="msg00813.html">Re: [MUD-Dev] Parlez vous NPC?</A></strong>, Matt Chatterley <a href="mailto:matt#mpc,dyn.ml.org">matt#mpc,dyn.ml.org</a>, Sun 22 Mar 1998, 12:46 GMT </LI> </UL> </LI> <LI><strong><A NAME="00808" HREF="msg00808.html">Re: [MUD-Dev] Dynamic Loading of Modules</A></strong>, Chris Gray <a href="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA">cg#ami-cg,GraySage.Edmonton.AB.CA</a>, Sat 21 Mar 1998, 17:58 GMT </LI> </UL></BLOCKQUOTE> </ul> <hr> <center> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] </center> <hr> </body> </html>