<!-- MHonArc v2.4.4 -->
<!--X-Subject: [MUD-Dev] Re: Databases: was Re: skill system -->
<!--X-From-R13: X Q Znjerapr <pynjNhaqre.rate.ftv.pbz> -->
<!--X-Date: Mon, 22 Jun 1998 15:57:31 -0700 -->
<!--X-Message-Id: 199806222257.PAA02180#under,engr.sgi.com -->
<!--X-Content-Type: text/plain -->
<!--X-Reference: 199806112143.OAA07401#beldin,snugharbor.com -->
<!--X-Head-End-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<title>MUD-Dev message, [MUD-Dev] Re: Databases: was Re: skill system</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="msg01164.html">Previous</a>
| <a href="msg01166.html">Next</a>
]
Thread:
[ <a href="msg01281.html">Previous</a>
| <a href="msg01172.html">Next</a>
]
Index:
[ <A HREF="author.html#01165">Author</A>
| <A HREF="#01165">Date</A>
| <A HREF="thread.html#01165">Thread</A>
]
<!--X-TopPNI-End-->
<!--X-MsgBody-->
<!--X-Subject-Header-Begin-->
<H1>[MUD-Dev] Re: Databases: was Re: skill system</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>: [MUD-Dev] Re: Databases: was Re: skill system </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, 22 Jun 1998 15:57:18 -0700</LI>
<LI><em>Reply-To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#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>
On Thu, 11 Jun 1998 14:43:16 -0700
T Alexander Popiel<popiel#beldin,snugharbor.com> wrote:
> In message: <<A HREF="msg00971.html">9193945826E7D0118BB4080009DBF8F611737D@TTECH</A>> jacob
> langthorn <jlangthorn#towertechinc,com> writes:
>> Has any one tried using Orical or SQL to manage the data base for
>> the mud? If so what sorta luck did you have?
> Yes. David Passmore and Lydia Leong did an experiment with MUSH,
> trying to run it off of one of the SQL engines. They found that it
> dramatically increased the speed of global searches, but increased
> the time to get stuff like the list of local objects by an order of
> magnitude.
> This fits with my beliefs about MUDs and classic DBs: they're
> optimized for different things, and should be so.
Do you know if they attempted to tune MUSH'es basic data model to fit
the new storage behaviours, or if they just attempted to supplant the
basic dbm with an SQL structure? The numbers you report would seem to
suggest a straight transplant without attempting to tune the data
model for the new medium (while I can't comment on the SQL world, a
few custom indexes or localised cacheing would handle the local object
list provlems poste haste in the DB2/Progress worlds I used to play
in).
--
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>
<ul compact><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><A NAME="01172" HREF="msg01172.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>
<ul compact><li><em>From:</em> "T. Alexander Popiel" <popiel#beldin,snugharbor.com></li></ul>
</UL></LI></UL>
<!--X-Follow-Ups-End-->
<!--X-References-->
<UL><LI><STRONG>References</STRONG>:
<UL>
<LI><STRONG><A NAME="00978" HREF="msg00978.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
<UL><LI><EM>From:</EM> "T. Alexander Popiel" <popiel#beldin,snugharbor.com></LI></UL></LI>
</UL></LI></UL>
<!--X-References-End-->
<!--X-BotPNI-->
<UL>
<LI>Prev by Date:
<STRONG><A HREF="msg01164.html">[MUD-Dev] Re: WIRED: Kilers have more fun</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg01166.html">[MUD-Dev] Re: Mud websites</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg01281.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg01172.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Index(es):
<UL>
<LI><A HREF="index.html#01165"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#01165"><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>[MUD-Dev] Re: Databases: was Re: skill system</STRONG>, <EM>(continued)</EM>
<ul compact>
<ul compact>
<ul compact>
<ul compact>
<LI><strong><A NAME="01229" HREF="msg01229.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Sat 27 Jun 1998, 02:00 GMT
</LI>
</ul>
<LI><strong><A NAME="01211" HREF="msg01211.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Fri 26 Jun 1998, 06:38 GMT
<UL>
<LI><strong><A NAME="01217" HREF="msg01217.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
s001gmu <a href="mailto:s001gmu#nova,wright.edu">s001gmu#nova,wright.edu</a>, Fri 26 Jun 1998, 17:01 GMT
<UL>
<LI><strong><A NAME="01281" HREF="msg01281.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Wed 01 Jul 1998, 02:01 GMT
</LI>
</UL>
</LI>
</UL>
</LI>
</ul>
<LI><strong><A NAME="01165" HREF="msg01165.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Mon 22 Jun 1998, 22:57 GMT
<UL>
<LI><strong><A NAME="01172" HREF="msg01172.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
T. Alexander Popiel <a href="mailto:popiel#beldin,snugharbor.com">popiel#beldin,snugharbor.com</a>, Tue 23 Jun 1998, 01:23 GMT
</LI>
</UL>
</LI>
</ul>
</ul>
</LI>
<LI><strong><A NAME="00964" HREF="msg00964.html">[MUD-Dev] META: Quoting, again.</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Thu 11 Jun 1998, 16:44 GMT
<LI><strong><A NAME="00963" HREF="msg00963.html">[MUD-Dev] Re:Telepathy Rules</A></strong>,
Michael.Willey <a href="mailto:Michael.Willey#abnamro,com">Michael.Willey#abnamro,com</a>, Thu 11 Jun 1998, 15:43 GMT
<UL>
<LI><strong><A NAME="01033" HREF="msg01033.html">[MUD-Dev] Re:Telepathy Rules</A></strong>,
Matt Chatterley <a href="mailto:matt#mpc,dyn.ml.org">matt#mpc,dyn.ml.org</a>, Sun 14 Jun 1998, 13:45 GMT
</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>
