<!-- MHonArc v2.4.4 -->
<!--X-Subject: Re: [MUD-Dev] Comments on the DB layer -->
<!--X-From-R13: pynjerapNphc.uc.pbz -->
<!--X-Date: from babe.globecomm.net [207.51.48.8] by mx4.ibm.net id 863200547.34704-1 Fri May 9 17:55:47 1997 -->
<!--X-Message-Id: 199705091801.LAA26665#xsvr3,cup.hp.com -->
<!--X-Content-Type: text/plain -->
<!--X-Reference: 9705071500.7z9n@ami-cg.GraySage.Edmonton.AB.CA -->
<!--X-Head-End-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<title>MUD-Dev message, Re: [MUD-Dev] Comments on the DB layer</title>
<!-- meta name="robots" content="noindex,nofollow" -->
<link rev="made" href="mailto:clawrenc#cup,hp.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="msg00346.html">Previous</a>
| <a href="msg00348.html">Next</a>
]
Thread:
[ <a href="msg00331.html">Previous</a>
| <a href="msg00330.html">Next</a>
]
Index:
[ <A HREF="author.html#00347">Author</A>
| <A HREF="#00347">Date</A>
| <A HREF="thread.html#00347">Thread</A>
]
<!--X-TopPNI-End-->
<!--X-MsgBody-->
<!--X-Subject-Header-Begin-->
<H1>Re: [MUD-Dev] Comments on the DB layer</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] Comments on the DB layer</LI>
<LI><em>From</em>: <A HREF="mailto:clawrenc#cup,hp.com">clawrenc#cup,hp.com</A></LI>
<LI><em>Date</em>: Thu, 08 May 97 10:58:12 -0700</LI>
<LI><em>Reply-to</em>: <A HREF="mailto:claw#null,net">claw#null,net</A></LI>
</UL>
<!--X-Head-of-Message-End-->
<!--X-Head-Body-Sep-Begin-->
<HR>
<!--X-Head-Body-Sep-End-->
<!--X-Body-of-Message-->
<PRE>
In <<A HREF="msg00331.html">9705071500.7z9n#ami-cg,GraySage.Edmonton.AB.CA</A>>, on 05/07/97
at 08:20 PM, cg#ami-cg,graysage.edmonton.ab.ca (Chris Gray) said:
>[Chris L:]
>:Now to go argue with myself and see if I really want some form of
>:query support for the DB. The appeal of having an admin able to do
>:something like:
>:
>: Show me all the users who killed mobile XXX in the last week,
>: cross referenced with a list of all the weapons and spells
>: they used in their successful attacks.
>:
>:is undeniable.
>Hmm. Methinks you are stepping beyond the bounds of what most people
>would think of as "a database to support a MUD system".
Yup. You bet.
>To do this
>you would have to never actually delete any database entity, so that
>all of the historical states are preserved. Your database would
>explode quickly!
My idea is to have the DB constantly trimmed back to a configured "max
age". That max age could be minutes, days, weeks, or even
months/years if you have enough disk space. This (obviously) time
limits the queries that could be done. but does also allow for a
certain level of recovery that is otherwise not possible.
eg:
A core object on which thousands of other objects depend
is accidentally deleted.
How do you recover?
>The next step of course is to not discard records
>produced by threads failing and being rescheduled - then you can find
>out how often you are getting "update conflicts" in your system.
Its easier to write a simple log for that sort of thing, indicating
rescedule rates and patterns of repeat offenders. Best case would be
to insert a generic callout that an admin client can plug into to
monitor what's going on and create/store/manage its own DB for the
events.
--
J C Lawrence Internet: claw#null,net
(Contractor) Internet: coder#ibm,net
---------------(*) Internet: clawrenc#cup,hp.com
...Honorary Member Clan McFUD -- Teamer's Avenging Monolith...
</PRE>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<HR>
<!--X-Follow-Ups-End-->
<!--X-References-->
<UL><LI><STRONG>References</STRONG>:
<UL>
<LI><STRONG><A NAME="00331" HREF="msg00331.html">Re: [MUD-Dev] Comments on the DB layer</A></STRONG>
<UL><LI><EM>From:</EM> cg#ami-cg,GraySage.Edmonton.AB.CA (Chris Gray)</LI></UL></LI>
</UL></LI></UL>
<!--X-References-End-->
<!--X-BotPNI-->
<UL>
<LI>Prev by Date:
<STRONG><A HREF="msg00346.html">Re: [MUD-Dev] (fwd) Re: Issues from the digests and Wout's list</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg00348.html">Re: [MUD-Dev] Random plotlines</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg00331.html">Re: [MUD-Dev] Comments on the DB layer</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg00330.html">Re: [MUD-Dev] Prepositions and parsing</A></STRONG>
</LI>
<LI>Index(es):
<UL>
<LI><A HREF="index.html#00347"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#00347"><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="00334" HREF="msg00334.html">InterMOO: a high-power MOO server (fwd)</A></strong>,
coder <a href="mailto:coder#ibm,net">coder#ibm,net</a>, Thu 08 May 1997, 09:57 GMT
<LI><strong><A NAME="00332" HREF="msg00332.html">Random plotlines</A></strong>,
Ling <a href="mailto:K.L.Lo-94#student,lut.ac.uk">K.L.Lo-94#student,lut.ac.uk</a>, Thu 08 May 1997, 04:27 GMT
<UL>
<LI><strong><A NAME="00350" HREF="msg00350.html">Re: [MUD-Dev] Random plotlines</A></strong>,
clawrenc <a href="mailto:clawrenc#cup,hp.com">clawrenc#cup,hp.com</a>, Sat 10 May 1997, 02:30 GMT
</LI>
</UL>
</LI>
<LI><strong><A NAME="00331" HREF="msg00331.html">Re: [MUD-Dev] Comments on the DB layer</A></strong>,
Chris Gray <a href="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA">cg#ami-cg,GraySage.Edmonton.AB.CA</a>, Wed 07 May 1997, 21:49 GMT
<UL>
<LI><strong><A NAME="00347" HREF="msg00347.html">Re: [MUD-Dev] Comments on the DB layer</A></strong>,
clawrenc <a href="mailto:clawrenc#cup,hp.com">clawrenc#cup,hp.com</a>, Sat 10 May 1997, 00:55 GMT
</LI>
</UL>
</LI>
<LI><strong><A NAME="00330" HREF="msg00330.html">Re: [MUD-Dev] Prepositions and parsing</A></strong>,
Chris Gray <a href="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA">cg#ami-cg,GraySage.Edmonton.AB.CA</a>, Wed 07 May 1997, 21:41 GMT
<LI><strong><A NAME="00327" HREF="msg00327.html">Re: [MUD-Dev] Comments on the DB layer</A></strong>,
Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Wed 07 May 1997, 12:31 GMT
<UL>
<LI><strong><A NAME="00359" HREF="msg00359.html">Re: [MUD-Dev] Comments on the DB layer</A></strong>,
clawrenc <a href="mailto:clawrenc#cup,hp.com">clawrenc#cup,hp.com</a>, Sat 10 May 1997, 20:18 GMT
</LI>
</UL>
<UL>
<li><Possible follow-up(s)><br>
<LI><strong><A NAME="00419" HREF="msg00419.html">Re: [MUD-Dev] Comments on the DB layer</A></strong>,
Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Tue 13 May 1997, 10:41 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>