<!-- MHonArc v2.4.4 --> <!--X-Subject: Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ?? --> <!--X-From-R13: Pra Uerrne <terrneNploreuvtujnl.arg> --> <!--X-Date: Thu, 26 Mar 1998 04:54:28 +0000 --> <!--X-Message-Id: Pine.LNX.3.96.980325215121.400A-100000#shamen,cyberhighway.net --> <!--X-Content-Type: text/plain --> <!--X-Reference: 199803250720.AAA25248#user2,inficad.com --> <!--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:greear#cyberhighway,net"> </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="msg00900.html">Previous</a> | <a href="msg00902.html">Next</a> ] Thread: [ <a href="msg00889.html">Previous</a> | <a href="msg00917.html">Next</a> ] Index: [ <A HREF="author.html#00901">Author</A> | <A HREF="#00901">Date</A> | <A HREF="thread.html#00901">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>: Ben Greear <<A HREF="mailto:greear#cyberhighway,net">greear#cyberhighway,net</A>></LI> <LI><em>Date</em>: Wed, 25 Mar 1998 21:53:19 -0700 (MST)</LI> </UL> <!--X-Head-of-Message-End--> <!--X-Head-Body-Sep-Begin--> <HR> <!--X-Head-Body-Sep-End--> <!--X-Body-of-Message--> <PRE> On Tue, 24 Mar 1998, Adam Wiggins wrote: > [Matt Chatterley:] > > On Sat, 21 Mar 1998, Ben Greear wrote: > > > The game will need to update it's persistant storage very often > > > to make this feasible. > > > I'm a little concerned about the performance hit on a DB, as I expect > > > this game server to bring a machine to it's knees anyway... > > > > A point to remember: Have the game *constantly* saving *small* amounts of > > data. Don't attempt to do what bases like PennMUSH do and dump a large > > amount of data at a regular interval - this causes quite a few problems > > (or rather, will if you are saving more than a few megabytes). > > I never got around to trying that idea that came up here (I can't remember > who thought of it - maybe it was me) a while back, about having a parallel > process running which did nothing but take a snapshot of the DB every n > units of time and then dump them to disk in a leisurely manner. > in-memory copy. In theory you could update it as often as every ten seconds. > > Naturally the only downside to this is that you essentially need double > the RAM, but I see this as a pretty small concession, considering the price > of memory these days. The crucial part you are missing here, is how to do the snapshot? You still have to pass (copy) the data, either through a pipe or socket or something. It would probably be about as quick to just write it to disk... Of course, I could be wrong... Ben > > Adam Ben Greear (greear#cyberhighway,net) <A HREF="http://www.primenet.com/~greear">http://www.primenet.com/~greear</A> Author of ScryMUD: mud.primenet.com 4444 <A HREF="http://www.primenet.com/~greear/ScryMUD/scry.html">http://www.primenet.com/~greear/ScryMUD/scry.html</A> </PRE> <!--X-Body-of-Message-End--> <!--X-MsgBody-End--> <!--X-Follow-Ups--> <HR> <ul compact><li><strong>Follow-Ups</strong>: <ul> <li><strong><A NAME="00917" HREF="msg00917.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong> <ul compact><li><em>From:</em> Orion Henry <orionZ#ix,netcom.com></li></ul> </UL></LI></UL> <!--X-Follow-Ups-End--> <!--X-References--> <UL><LI><STRONG>References</STRONG>: <UL> <LI><STRONG><A NAME="00889" HREF="msg00889.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> <UL><LI><EM>From:</EM> Adam Wiggins <nightfall#user2,inficad.com></LI></UL></LI> </UL></LI></UL> <!--X-References-End--> <!--X-BotPNI--> <UL> <LI>Prev by Date: <STRONG><A HREF="msg00900.html">Re: [MUD-Dev] UML/Commercial v Free Muds</A></STRONG> </LI> <LI>Next by Date: <STRONG><A HREF="msg00902.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> </LI> <LI>Prev by thread: <STRONG><A HREF="msg00889.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG> </LI> <LI>Next by thread: <STRONG><A HREF="msg00917.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#00901"><STRONG>Date</STRONG></A></LI> <LI><A HREF="thread.html#00901"><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> <ul compact> <ul compact> <LI><strong><A NAME="00829" HREF="msg00829.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:08 GMT </LI> <LI><strong><A NAME="00858" HREF="msg00858.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:43 GMT </LI> </ul> <LI><strong><A NAME="00856" HREF="msg00856.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:38 GMT </LI> <LI><strong><A NAME="00889" HREF="msg00889.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, Adam Wiggins <a href="mailto:nightfall#user2,inficad.com">nightfall#user2,inficad.com</a>, Wed 25 Mar 1998, 07:18 GMT <UL> <LI><strong><A NAME="00901" HREF="msg00901.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>, Thu 26 Mar 1998, 04:54 GMT <UL> <LI><strong><A NAME="00917" HREF="msg00917.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, Orion Henry <a href="mailto:orionZ#ix,netcom.com">orionZ#ix,netcom.com</a>, Tue 31 Mar 1998, 02:42 GMT <UL> <LI><strong><A NAME="00918" HREF="msg00918.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>, Tue 31 Mar 1998, 05:22 GMT <UL> <LI><strong><A NAME="00919" HREF="msg00919.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, Nathan F Yospe <a href="mailto:yospe#hawaii,edu">yospe#hawaii,edu</a>, Tue 31 Mar 1998, 18:23 GMT <UL> <LI><strong><A NAME="00925" HREF="msg00925.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>, Wed 01 Apr 1998, 04:41 GMT </LI> </UL> </LI> </UL> </LI> </UL> </LI> </UL> </LI> </UL> </LI> </ul> </ul> </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>