<!-- MHonArc v2.4.4 -->
<!--X-Subject: Re: [MUD-Dev] Database back ends -->
<!--X-From-R13: Uert Gaqrejbbq <thaqrejbbqNqbarg.pbz> -->
<!--X-Date: Wed, 19 Apr 2000 15:53:27 -0700 -->
<!--X-Message-Id: 20000419221346.10229.qmail#wafer,donet.com -->
<!--X-Content-Type: text/plain -->
<!--X-Reference: C07FC03B3050D311A45800600821481D03B4F7E6#logixmail,saleslogix.com -->
<!--X-Head-End-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<title>MUD-Dev message, Re: [MUD-Dev] Database back ends</title>
<!-- meta name="robots" content="noindex,nofollow" -->
<link rev="made" href="mailto:gunderwood#donet,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="msg00476.html">Previous</a>
| <a href="msg00477.html">Next</a>
]
Thread:
[ <a href="msg00467.html">Previous</a>
| <a href="msg00477.html">Next</a>
]
Index:
[ <A HREF="author.html#00474">Author</A>
| <A HREF="#00474">Date</A>
| <A HREF="thread.html#00474">Thread</A>
]
<!--X-TopPNI-End-->
<!--X-MsgBody-->
<!--X-Subject-Header-Begin-->
<H1>Re: [MUD-Dev] Database back ends</H1>
<HR>
<!--X-Subject-Header-End-->
<!--X-Head-of-Message-->
<UL>
<LI><em>To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#kanga,nu</A></LI>
<LI><em>Subject</em>: Re: [MUD-Dev] Database back ends</LI>
<LI><em>From</em>: Greg Underwood <<A HREF="mailto:gunderwood#donet,com">gunderwood#donet,com</A>></LI>
<LI><em>Date</em>: Wed, 19 Apr 2000 22:13:46 GMT</LI>
<LI><em>Reply-To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#kanga,nu</A></LI>
<LI><em>Sender</em>: <A HREF="mailto:mud-dev-admin#kanga,nu">mud-dev-admin#kanga,nu</A></LI>
</UL>
<!--X-Head-of-Message-End-->
<!--X-Head-Body-Sep-Begin-->
<HR>
<!--X-Head-Body-Sep-End-->
<!--X-Body-of-Message-->
<PRE>
dwacks#saleslogix,com writes:
> My question is: In general how do you feel about using a DB back end and
> what problems do you see with this.
While I've not actaully implemented a Commercial Off The Shelf (COTS) DB as
a back end, I've toyed with it. The major concern that I had was
performance. Where do you draw the line between what you keep in the DB
and what you keep in local memory? Putting everything in the DB requires
that all actions within the game use SQL to actually do anything.
Depending on the target size of your MUD this may work out ok, or may put
too much strain on the SQL interpreter. I think the first thing you'll
want to do is determine the scope of the project (IE: how many simultaneous
player connections, how much DB access per player?) and then do some
performance testing on the various DB back ends.
Basically, as with anything in computers, it's a set of trade-offs. Do you
want flexability and easy crash recovery/less crashes? Put more in the DB.
Do you want to be able to run 5000 players online at once? Methinks
you'll need something more custom-built.
I've got a friend who works for a commercial game company, doing basically
what you want, but with Oracle. I'll see if he's willing/able to comment
on any of the troubles he ran in to.
A fascinating thought I had a while ago was that, well, since the data
structures by and large determine the way the game works, wouldn't it be
neet to have spells that could actually alter the structure of the
database? I mean, SQL commands can let you do things like add and drop
tables, fields etc. Why limit the scope of the spells to simply altering
values within the tables?
-Greg
_______________________________________________
MUD-Dev mailing list
MUD-Dev#kanga,nu
<A HREF="http://www.kanga.nu/lists/listinfo/mud-dev">http://www.kanga.nu/lists/listinfo/mud-dev</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="00481" HREF="msg00481.html">[MUD-Dev] Massive Connections</A></strong>
<ul compact><li><em>From:</em> Christopher Kohnert <cjkohner#mail,uccs.edu></li></ul>
<li><strong><A NAME="00477" HREF="msg00477.html">Re: [MUD-Dev] Database back ends</A></strong>
<ul compact><li><em>From:</em> "Quiet" <colborne#gte,net></li></ul>
</UL></LI></UL>
<!--X-Follow-Ups-End-->
<!--X-References-->
<UL><LI><STRONG>References</STRONG>:
<UL>
<LI><STRONG><A NAME="00467" HREF="msg00467.html">[MUD-Dev] Database back ends</A></STRONG>
<UL><LI><EM>From:</EM> dwacks#saleslogix,com</LI></UL></LI>
</UL></LI></UL>
<!--X-References-End-->
<!--X-BotPNI-->
<UL>
<LI>Prev by Date:
<STRONG><A HREF="msg00476.html">Re: RE: [MUD-Dev] Justifying twinking</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg00477.html">Re: [MUD-Dev] Database back ends</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg00467.html">[MUD-Dev] Database back ends</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg00477.html">Re: [MUD-Dev] Database back ends</A></STRONG>
</LI>
<LI>Index(es):
<UL>
<LI><A HREF="index.html#00474"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#00474"><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><A NAME="00475" HREF="msg00475.html">[MUD-Dev] Simpson's "In-Game Economics of UO"</A></strong>,
Timothy Dang <a href="mailto:tdang#U,Arizona.EDU">tdang#U,Arizona.EDU</a>, Wed 19 Apr 2000, 22:53 GMT
<LI><strong><A NAME="00472" HREF="msg00472.html">Re: Re PRIVATE [MUD-Dev] Justifying twinking</A></strong>,
Josh Olson <a href="mailto:jolson#micron,net">jolson#micron,net</a>, Wed 19 Apr 2000, 18:55 GMT
<LI><strong><A NAME="00467" HREF="msg00467.html">[MUD-Dev] Database back ends</A></strong>,
dwacks <a href="mailto:dwacks#saleslogix,com">dwacks#saleslogix,com</a>, Wed 19 Apr 2000, 18:55 GMT
<UL>
<LI><strong><A NAME="00474" HREF="msg00474.html">Re: [MUD-Dev] Database back ends</A></strong>,
Greg Underwood <a href="mailto:gunderwood#donet,com">gunderwood#donet,com</a>, Wed 19 Apr 2000, 22:53 GMT
<UL>
<LI><strong><A NAME="00477" HREF="msg00477.html">Re: [MUD-Dev] Database back ends</A></strong>,
Quiet <a href="mailto:colborne#gte,net">colborne#gte,net</a>, Wed 19 Apr 2000, 23:15 GMT
</LI>
<LI><strong><A NAME="00481" HREF="msg00481.html">[MUD-Dev] Massive Connections</A></strong>,
Christopher Kohnert <a href="mailto:cjkohner#mail,uccs.edu">cjkohner#mail,uccs.edu</a>, Thu 20 Apr 2000, 01:34 GMT
<UL>
<LI><strong><A NAME="00483" HREF="msg00483.html">Re: [MUD-Dev] Massive Connections</A></strong>,
Kevin Scott London <a href="mailto:london#cs,utk.edu">london#cs,utk.edu</a>, Thu 20 Apr 2000, 02:52 GMT
<UL>
<LI><strong><A NAME="00484" HREF="msg00484.html">Re: [MUD-Dev] Massive Connections</A></strong>,
Christopher Kohnert <a href="mailto:cjkohner#mail,uccs.edu">cjkohner#mail,uccs.edu</a>, Thu 20 Apr 2000, 03:30 GMT
</LI>
</UL>
</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>