<!-- MHonArc v2.4.4 -->
<!--X-Subject: Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases) -->
<!--X-From-R13: "Xba O. Znzoreg" <wyflfvapNvk.argpbz.pbz> -->
<!--X-Date: Mon, 17 Jan 2000 11:52:57 -0800 -->
<!--X-Message-Id: 002a01bf60d5$c0805680$020101df@JonLambert -->
<!--X-Content-Type: text/plain -->
<!--X-Head-End-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<title>MUD-Dev message, Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions o</title>
<!-- meta name="robots" content="noindex,nofollow" -->
<link rev="made" href="mailto:jlsysinc#ix,netcom.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="msg00103.html">Previous</a>
| <a href="msg00104.html">Next</a>
]
Thread:
[ <a href="msg00099.html">Previous</a>
| <a href="msg00109.html">Next</a>
]
Index:
[ <A HREF="author.html#00106">Author</A>
| <A HREF="#00106">Date</A>
| <A HREF="thread.html#00106">Thread</A>
]
<!--X-TopPNI-End-->
<!--X-MsgBody-->
<!--X-Subject-Header-Begin-->
<H1>Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</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] Databases (was Re: Commercial-use Restrictions on Code Bases)</LI>
<LI><em>From</em>: "Jon A. Lambert" <<A HREF="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</A>></LI>
<LI><em>Date</em>: Mon, 17 Jan 2000 05:17:20 -0500</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>
Charles Hughes wrote:
>
>At the risk of being slapped by a mackerel, who here really thinks they
>can do a better database design than those afforded by the likes of the
>free or commercial databases? [I'll ask those here who've actually
>worked on these databases not to chime in. :)]
>
>It seems to me that segregating the database issues and then simply using
>a database is far better than creating a new one. This would change
>the "databases/memory management" division above into two divisions -
>database usage, memory management.
>
>Yes? No?
It depends on what you mean by "database". If you mean relational
databases (RDBMSs), then yes we can and do a lot better in terms of
performance in implementing our own mud databases. RDMSs work
better with batch-access patterns or operations on "sets" of data, or
as Alexander Popeil stated, "large grain transactions".
For instance many existing muds' database access patterns are already
optimized for the constructs:
select * from MUD_DB where id = "#162";
update MUD_DB set name = "troll" where id = "#162";
insert object_data into MUD_DB;
and will almost always outperform an RDMS (barring some really
shoddy construction).
On the other hand set operations like,
select * from MUD_DB where type = "sword";
update MUD_DB set damage = "2d6"
where type = "sword" and material = "steel";
will be done very well in an RDMS. However set operations like this
are not often done in existing mud designs.
I agree generally with your comments about partitioning a server.
However, I view database and memory management as a single
sub-system, rather than making an arbitrary distinction between where
the data or objects reside. I suppose it depends on how one chooses
to implement persistence.
--
--* Jon A. Lambert - TychoMUD Email: jlsysinc#nospam,ix.netcom.com *--
--* Mud Server Developer's Page <<A HREF="http://jlsysinc.home.netcom.com">http://jlsysinc.home.netcom.com</A>> *--
--* "No Free man shall ever be debarred the use of arms." Thomas Jefferson *--
_______________________________________________
MUD-Dev maillist - 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>
<!--X-Follow-Ups-End-->
<!--X-References-->
<!--X-References-End-->
<!--X-BotPNI-->
<UL>
<LI>Prev by Date:
<STRONG><A HREF="msg00103.html">Re: [MUD-Dev] Question about multithreaded servers</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg00104.html">Re: [MUD-Dev] Re: Databases</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg00099.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg00109.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></STRONG>
</LI>
<LI>Index(es):
<UL>
<LI><A HREF="index.html#00106"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#00106"><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] Re: Databases</STRONG>, <EM>(continued)</EM>
<ul compact>
<ul compact>
<ul compact>
<ul compact>
<ul compact>
<LI><strong><A NAME="00245" HREF="msg00245.html">Re: [MUD-Dev] Re: Databases</A></strong>,
J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sun 30 Jan 2000, 21:45 GMT
</LI>
</ul>
</ul>
</ul>
</ul>
</ul>
</LI>
<LI><strong><A NAME="00096" HREF="msg00096.html">[MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>,
Charles Hughes <a href="mailto:charles.hughes#bigfoot,com">charles.hughes#bigfoot,com</a>, Sun 16 Jan 2000, 01:56 GMT
<UL>
<LI><strong><A NAME="00242" HREF="msg00242.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>,
J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sun 30 Jan 2000, 21:21 GMT
</LI>
</UL>
<UL>
<li><Possible follow-up(s)><br>
<LI><strong><A NAME="00099" HREF="msg00099.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>,
cg <a href="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA">cg#ami-cg,GraySage.Edmonton.AB.CA</a>, Sun 16 Jan 2000, 18:59 GMT
</LI>
<LI><strong><A NAME="00106" HREF="msg00106.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>,
Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Mon 17 Jan 2000, 19:52 GMT
</LI>
<LI><strong><A NAME="00109" HREF="msg00109.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>,
Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Mon 17 Jan 2000, 22:02 GMT
</LI>
</UL>
</LI>
<LI><strong><A NAME="00089" HREF="msg00089.html">[MUD-Dev] Re: Commercial-use Restrictions on Code Bases (was: help me find 100% fre (fwd)</A></strong>,
J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sat 15 Jan 2000, 04:29 GMT
<UL>
<li><Possible follow-up(s)><br>
<LI><strong><A NAME="00090" HREF="msg00090.html">[MUD-Dev] Re: Commercial-use Restrictions on Code Bases (was: help me find 100% fre (fwd)</A></strong>,
J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sat 15 Jan 2000, 04:31 GMT
</LI>
</UL>
</LI>
<LI><strong><A NAME="00086" HREF="msg00086.html">[MUD-Dev] Community Relations</A></strong>,
Dundee <a href="mailto:SkeptAck#antisocial,com">SkeptAck#antisocial,com</a>, Fri 14 Jan 2000, 18:39 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>