1998Q1/
<!-- MHonArc v2.4.4 -->
<!--X-Subject: Re: [MUD&#45;Dev] World Persistence, flat files v/s DB v/s ?? -->
<!--X-From-R13: X Q Znjerapr <pynjNhaqre.rate.ftv.pbz> -->
<!--X-Date: Wed, 25 Mar 1998 00:17:03 +0000 -->
<!--X-Message-Id: 199803241825.KAA58666#under,engr.sgi.com -->
<!--X-Content-Type: text/plain -->
<!--X-Reference: Pine.LNX.3.95.980324081513.5400C&#45;100000#cornholio,new.ox.ac.uk -->
<!--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: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>
[&nbsp;<a href="../">Other Periods</a>
&nbsp;|&nbsp;<a href="../../">Other mailing lists</a>
&nbsp;|&nbsp;<a href="/search.php3">Search</a>
&nbsp;]
<br clear=all><hr>
<!--X-Body-Begin-->
<!--X-User-Header-->
<!--X-User-Header-End-->
<!--X-TopPNI-->

Date:&nbsp;
[&nbsp;<a href="msg00878.html">Previous</a>
&nbsp;|&nbsp;<a href="msg00880.html">Next</a>
&nbsp;]
&nbsp;&nbsp;&nbsp;&nbsp;
Thread:&nbsp;
[&nbsp;<a href="msg00872.html">Previous</a>
&nbsp;|&nbsp;<a href="msg00891.html">Next</a>
&nbsp;]
&nbsp;&nbsp;&nbsp;&nbsp;
Index:&nbsp;
[&nbsp;<A HREF="author.html#00879">Author</A>
&nbsp;|&nbsp;<A HREF="#00879">Date</A>
&nbsp;|&nbsp;<A HREF="thread.html#00879">Thread</A>
&nbsp;]

<!--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>: J C Lawrence &lt;<A HREF="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</A>&gt;</LI>
<LI><em>Date</em>: Tue, 24 Mar 1998 10:25:42 -0800</LI>
</UL>
<!--X-Head-of-Message-End-->
<!--X-Head-Body-Sep-Begin-->
<HR>
<!--X-Head-Body-Sep-End-->
<!--X-Body-of-Message-->
<PRE>
On Tue, 24 Mar 1998 00:20:23 PST8PDT 
Joel Dillon&lt;emily#cornholio,new.ox.ac.uk&gt; wrote:
&gt; On Mon, 23 Mar 1998, J C Lawrence wrote:
&gt;&gt; On Sun, 22 Mar 1998 05:44:12 PST8PDT Matt
&gt;&gt; Chatterley&lt;matt#mpc,dyn.ml.org&gt; wrote:

&gt;&gt; While threads are cheap, they are not free.  What are you going to
&gt;&gt; do when you get 500 players online?  1,000?  5,000?  1,000 threads
&gt;&gt; will drag any OS I know of on any platform costing less than
&gt;&gt; US$50,000 to its knees.

&gt; Most servers will be brought to their knees by 5,000 people
&gt; whether the server is multi- or single-threaded ;) At that point you
&gt; need to start thinking about distributed servers.

True -- tho I'd wager an HP K400 or SGI Onyx with enough processors
and RAM woulb be able to handle it, but yes. they are not "most"
machines. 

Some loose numbers:

  I played with a couple machines at home this weekend.  On one end
was an a twin 180MHz P'Pro, on the other was a 333MHz Alpha, both with
128Meg RAM, and interconnected via _two_ 100base-T nets (two NICs in
each machine).  

  I threw a simple server mockup on the Alpha which did nothing but
accept connections and spit repetitive copies of the Gettysburg
address with random timing gaps up to 5 seconds between the lines to
simulate "realistic loads",a nd threw away all incoming traffic.  On
the other machine I threw up a simple multiplexed client which did
nothing but open connections to the server and do the exact same
thing: it spat out copies of the address but with a 30 second
randomity (big spacing, but long average line length), and threw away
all the inbound data.  Connections were evenly spread across the two
nets.  Both the server and client were multi-threaded with IO being
handled by an asynchronous pool of IO threads as discussed here
previously.

  This is of course a vastly unbalanced excercise which really did
nothing but excercise the respective IP stacks.  Most importantlyly it
did not excercise the DASD subsystems, page fault characteristics, or
integer performance.  Then again, it only took a couple hours to set
up and run...

  I got up to roughly 3,800 connections before response time started
to suffer enough to impact play (feel of thumb).  I suspect that the
real bottleneck was not mechanical, but the drivers for the Tulib
based NIC's I was running on the Alpha (RedHat Linux/Alpha 5.0).

  Of course then the chap I was selling the machines to came in, and I 
had to tear it all down to throw it in the back of his MG...

-- 
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>
<!--X-Follow-Ups-End-->
<!--X-References-->
<UL><LI><STRONG>References</STRONG>:
<UL>
<LI><STRONG><A NAME="00872" HREF="msg00872.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG>
<UL><LI><EM>From:</EM> Joel Dillon &lt;emily#cornholio,new.ox.ac.uk&gt;</LI></UL></LI>
</UL></LI></UL>
<!--X-References-End-->
<!--X-BotPNI-->
<UL>
<LI>Prev by Date:
<STRONG><A HREF="msg00878.html">Re: [MUD-Dev] META: Broken mail headers</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg00880.html">UML/Commercial v Free Muds</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg00872.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg00891.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#00879"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#00879"><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>
<LI><strong><A NAME="00816" HREF="msg00816.html">Re: [MUD-Dev]  World Persistence, flat files v/s DB v/s ??</A></strong>, 
Joel Dillon <a href="mailto:emily#cornholio,new.ox.ac.uk">emily#cornholio,new.ox.ac.uk</a>, Sun 22 Mar 1998, 13:55 GMT
</LI>
<LI><strong><A NAME="00817" HREF="msg00817.html">Another recruit for the list?</A></strong>, 
Joel Dillon <a href="mailto:emily#cornholio,new.ox.ac.uk">emily#cornholio,new.ox.ac.uk</a>, Sun 22 Mar 1998, 15:29 GMT
</LI>
<LI><strong><A NAME="00855" HREF="msg00855.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:38 GMT
<UL>
<LI><strong><A NAME="00872" HREF="msg00872.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, 
Joel Dillon <a href="mailto:emily#cornholio,new.ox.ac.uk">emily#cornholio,new.ox.ac.uk</a>, Tue 24 Mar 1998, 08:16 GMT
<UL>
<LI><strong><A NAME="00879" HREF="msg00879.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>, Wed 25 Mar 1998, 00:17 GMT
</LI>
</UL>
</LI>
<LI><strong><A NAME="00891" HREF="msg00891.html">Re: [MUD-Dev] World Persistence, flat files v/s DB v/s ??</A></strong>, 
Matt Chatterley <a href="mailto:matt#mpc,dyn.ml.org">matt#mpc,dyn.ml.org</a>, Wed 25 Mar 1998, 08:17 GMT
</LI>
</UL>
</LI>
</ul>
</ul>
<LI><strong><A NAME="00826" HREF="msg00826.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:00 GMT
<UL>
<LI><strong><A NAME="00829" HREF="msg00829.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:08 GMT
</LI>
<LI><strong><A NAME="00858" HREF="msg00858.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:43 GMT
</LI>
</UL>
</LI>
</ul>
</ul>
</LI>
</UL></BLOCKQUOTE>

</ul>
<hr>
<center>
[&nbsp;<a href="../">Other Periods</a>
&nbsp;|&nbsp;<a href="../../">Other mailing lists</a>
&nbsp;|&nbsp;<a href="/search.php3">Search</a>
&nbsp;]
</center>
<hr>
</body>
</html>