<!-- MHonArc v2.4.4 -->
<!--X-Subject: Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ?? -->
<!--X-From-R13: Uert [hag <tertNhav-pbea.qrzba.pb.hx> -->
<!--X-Date: Sun, 22 Mar 1998 17:36:23 +0000 -->
<!--X-Message-Id: Pine.LNX.3.91.980322120613.8247C-100000@uni-corn.demon.co.uk -->
<!--X-Content-Type: text/plain -->
<!--X-Reference: Pine.LNX.3.96.980321223049.1095A-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:greg#uni-corn,demon.co.uk">
</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="msg00817.html">Previous</a>
| <a href="msg00819.html">Next</a>
]
Thread:
[ <a href="msg00926.html">Previous</a>
| <a href="msg00828.html">Next</a>
]
Index:
[ <A HREF="author.html#00818">Author</A>
| <A HREF="#00818">Date</A>
| <A HREF="thread.html#00818">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>: Greg Munt <<A HREF="mailto:greg#uni-corn,demon.co.uk">greg#uni-corn,demon.co.uk</A>></LI>
<LI><em>Date</em>: Sun, 22 Mar 1998 17:33:24 +0100 (GMT+0100)</LI>
</UL>
<!--X-Head-of-Message-End-->
<!--X-Head-Body-Sep-Begin-->
<HR>
<!--X-Head-Body-Sep-End-->
<!--X-Body-of-Message-->
<PRE>
On Sat, 21 Mar 1998, Ben Greear wrote:
> The game will need to update it's persistant storage very often
> to make this feasible.
>
> In my current game, I use ascii based flat files. I don't think
> this will work so well for the space game.
In the TinyMUD that I ran, the database was saved as an ASCII flat file,
with objects delimited by ^H. The database was dumped at regular intervals.
There was a noticable drop in performance when a large database was
dumped. Various methods were tried to overcome this problem, ranging from
running the DB dump as a child process, to the use of dumping cycles
(saving n kilobytes, pausing for a few seconds, then saving a bit more, etc)
The only real solution was to install more physical memory. The database
was reasonably persistent, seeing as the most recent dump available was
no more than 30 minutes old (if the database was dumped every 30 minutes).
> The two things I'm pondering now are binary flat files (one per object,
> a collection of objects?? I dunno) or a database.
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 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...
Not all databases use SQL. Some are even 'fast' - I believe that dbm
falls into this category, although there are issues with database
corruption that may need to be considered. Take a look at the FreeDB
list. Personally, I may take a look at a few, and design my own. This is
really only for the 'fun' value, though :) I probably won't save the
entire DB, but only objects which have changed since the last save.
I would most definitely be interested in discussions of various database
models, as used by various list members. The format of the physical DB
file is of most interest right now, although retrieval speed, algorithms
and cache handling would also be of relevance - as would 'standards', and
standard DB models, none of which I can remember the names of right now.
> I'd be interested to hear any suggestions you might have.. >
> Also, as a java server, I don't think I can do a select on incomming
> data. I think a thread for every player is a bit much...any suggestions
> here?
I do not know Java (yet) - but I would agree that a thread for every
socket is not the way to go.
> 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>
[Bored of ScryMUD already?;)]
--
Greg Munt, greg#uni-corn,demon.co.uk; <A HREF="http://www.uni-corn.demon.co.uk/ubiquity/">http://www.uni-corn.demon.co.uk/ubiquity/</A>
"Deliver yesterday, code today, think tomorrow."
</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="00828" HREF="msg00828.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>
<ul compact><li><em>From:</em> Ben Greear <greear#cyberhighway,net></li></ul>
</UL></LI></UL>
<!--X-Follow-Ups-End-->
<!--X-References-->
<UL><LI><STRONG>References</STRONG>:
<UL>
<LI><STRONG><A NAME="00810" HREF="msg00810.html">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="msg00817.html">Another recruit for the list?</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg00819.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg00926.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg00828.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#00818"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#00818"><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>
<ul compact>
<ul compact>
<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>
<LI><strong><A NAME="00926" HREF="msg00926.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>,
Vadim Tkachenko <a href="mailto:vt#freehold,crocodile.org">vt#freehold,crocodile.org</a>, Wed 01 Apr 1998, 05:33 GMT
</LI>
</UL>
</LI>
</UL>
</LI>
</ul>
</ul>
</ul>
</ul>
<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>
</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>
