August 2002
- TECH: Path MTU Discovery Eli Stevens
- Matt's java problems.... Adam
- Non-traditional monsters? Jack Britt
- Non-traditional monsters? Brandon J. Van Every
- Non-traditional monsters? Jack Britt
- Non-traditional monsters? Brandon J. Van Every
- Non-traditional monsters? Jack Britt
- Non-traditional monsters? Kwon Ekstrom
- Non-traditional monsters? eric
- Non-traditional monsters? Brandon J. Van Every
- Non-traditional monsters? Damion Schubert
- Non-traditional monsters? Bruce Mitchener
- Non-traditional monsters? Edward Glowacki
- Non-traditional monsters? szii@sziisoft.com
- Non-traditional monsters? Nathan F. Yospe
- OT: Gen Con? Michael Tresca
- Unique items vs. item references Brian Hook
- Unique items vs. item references Vincent Archer
- Unique items vs. item references shren
- Unique items vs. item references Brandon J. Van Every
- Unique items vs. item references lynx@lynx.purrsia.com
- Unique items vs. item references Bruce Mitchener
- Unique items vs. item references Brandon J. Van Every
- Unique items vs. item references fred@clift.org
- Unique items vs. item references shren
- Unique items vs. item references Brandon J. Van Every
- Unique items vs. item references Damion Schubert
- Unique items vs. item references Freeman, Jeff
- Unique items vs. item references Harrok
- Unique items vs. item references Zach Collins {Siege}
- Unique items vs. item references fred@clift.org
- Unique items vs. item references Vincent Archer
- Unique items vs. item references Koster, Raph
- Unique items vs. item references Dave Rickey
- Unique items vs. item references Vincent Archer
- Unique items vs. item references Dave Rickey
- Unique items vs. item references Daniel.Harman@barclayscapital.com
- Unique items vs. item references Sean Kelly
- Unique items vs. item references Damion Schubert
- Unique items vs. item references Smith, David {Lynchburg}
- Unique items vs. item references Sean Kelly
- Character skill amplifying player skill Brian Hook
- Character skill amplifying player skill Daniel.Harman@barclayscapital.com
- Character skill amplifying player skill Ling Lo
- narrative Bruce Mitchener
- narrative Brandon J. Van Every
- narrative Robert Zubek
- narrative Brandon J. Van Every
- narrative Sasha Hart
- narrative Benjamin Tolputt
- [Fwd: [Algorithms] ANNOUNCE: updated Chunked LOD demo] Bruce Mitchener
- (no subject) Jack Britt
- (no subject) Brandon J. Van Every
- (no subject) Jack Britt
- (no subject) Jeff Lindsey
- (no subject) Karl Bastiman
- (no subject) Zach Collins {Siege}
- Advertising Thread Rayzam
- Advertising Thread Brandon J. Van Every
- Advertising Thread Matt Mihaly
- Advertising Thread Brandon J. Van Every
- Advertising Thread Russ Whiteman
- Advertising Thread Koster, Raph
- Advertising Thread Russ Whiteman
- Advertising Thread Kristen Koster
- Advertising Thread Rayzam
- Advertising Thread Brandon J. Van Every
- Advertising Thread Shannon Appelcline
- Advertising Thread Brandon J. Van Every
- Advertising Thread Rayzam
- Advertising Thread Matt Mihaly
- Advertising Thread Daniel.Harman@barclayscapital.com
- Advertising Thread Brandon J. Van Every
- Advertising Thread Daniel.Harman@barclayscapital.com
- Advertising Thread Matt Mihaly
- Advertising Thread Jeremy Noetzelman
- Advertising Thread Amanda Walker
- Advertising Thread Matt Mihaly
- Advertising Thread Jeremy Gaffney
- Advertising Thread Matt Mihaly
- Advertising Thread Michael Tresca
- Advertising Thread Dave Rickey
- Advertising Thread Matt Mihaly
- skills (was (no subject)) Travis Casey
- The total DBMS approach (was: Unique items vs. item references) Derek Licciardi
- The total DBMS approach (was: Unique items vs. item references) Crosbie Fitch
- The total DBMS approach (was: Unique items vs. item references) Valerio Santinelli
----- Original Message -----
From: "Derek Licciardi" <kressilac@insightBB.com>
> From: Smith, David (Lynchburg)
>> On Mon, 5 Aug 2002, Brian Hook wrote:
>> This may be a tangential question, but I'm interested to hear
>> thoughts on it. I'm (fortunately) still designing my approach to
>> the database, but I see two approaches that have merits, and I
>> wonder if anyone's found out more about the real-life pros and
>> cons.
> I believe you could build a database based architecture like you
> describe in scenario one. I also think that it would be cost
> prohibitive to do so for anything larger than a normal sized MUD.
> If you're talking about MMOG size, then you're looking at severe
> costs.(relative to a typical MMOG or game project) In effect you
> would be building something the size of SAP, PeopleSoft, or Oracle
> Applications for your transaction system. Like SAP, given enough
> hardware, it runs amazingly fast. Oracle is capable of handling
> the NASDAQ stock market. It is certainly capable of handling the
> processing requirements of a MUD or even an MMOG. The question
> quickly becomes a money one. SAP, installations run into the 20 -
> 50 million dollar range and higher to achieve MMOG style subsecond
> performance for thousands of users. The benefit of having a
> standardized interface to the game data through SQL simply does
> not outweigh the significant increase in cost.
I agree with your statement. Having a total DBMS approach is going
to be heavy on the costs side. There's no way to cut the costs using
an Open Source RDBMS since no one can compete with the one you
talked about in your previous statement.
> For a MUD, this might be totally different. If anyone gives the
> approach a try, I'd love to hear how it came out and would be very
> willing to offer database design advice if needed. Even with a
> MUD, you're probably not going to be able to do it without a
> nearly midrange server. We're talking about SCSI RAID arrays,
> Multiple processors, Gobs of memory, and a qualified DBA that can
> tune like a madman. No matter how you position the database,
> you're going to want to write an interface in front of the
> database that allows communication with the game client. The game
> client should never have the ability to fire SQL straight to the
> database.
I am not going to try it with a MUD, but I was thinking about giving
it a try with UOX3 and MySQL. UOX3 is an Ultima Online server
emulator and is well suited to this kind of conversion. And MySQL is
the choice because it's free and it's available both for Windows and
Linux which are the main platforms used by the emulator. Maybe we
could start working on the project together just for the fun and to
see if that approach could be comparable to the actual all-in-memory
model.
> The prohibitive cost is probably why an all DBMS approach has not
> been tried by any of the MMOGs today. These games do not use a
> database as its main live datastore and instead opt for something
> proprietary. I believe DAOCs post mortem stated they were going
> to use Oracle until the 900K price tag was dropped on someone's
> desk. With other systems such as MySQL and Postgres, I do not
> believe you can achieve what you would be striving for in your
> total DB approach. To achieve the total DB approach, you will
> need MS SQL Server, DB2, or Oracle along with all of the costs
> associated with those databases.
I once heard that Ultima Online was actually using Oracle for all
data storage. I still don't know how it interfaced with the DBMS,
though. Maybe Ralph could enlighten us?
--
Valerio Santinelli
One Man Crew Gaming Community (http://www.onemancrew.org)
My Lab (http://tanis.hateseed.com)
HateSeed.com Founder (http://www.hateseed.com)
In Flames Italia Webmaster (http://www.inflames.it) - The total DBMS approach (was: Unique items vs. item references) Russ Whiteman
- Socket Code Stephen Miller
- Socket Code Smith, David {Lynchburg}
- Socket Code Blane Bramble
- Origins of "carebear" Koster, Raph
- Origins of "carebear" Steve {Bloo} Daniels
- Origins of "carebear" Koster, Raph
- Origins of "carebear" Madrona Tree
- Origins of "carebear" Calandryll
- Origins of "carebear" Dave Trump
- Origins of "carebear" Koster, Raph
- The total DBMS approach Aaron "the mad man" Weeks
- The total DBMS approach Derek Licciardi
- The total DBMS approach Hanz, Rob
- The total DBMS approach Daniel.Harman@barclayscapital.com
- The total DBMS approach Sean Kelly
- The total DBMS approach Hanz, Rob
- The total DBMS approach Elia Mòˆrling
- The total DBMS approach Daniel.Harman@barclayscapital.com
- The total DBMS approach Ian Macintosh
- Otherland Richard A. Bartle
- Efficiency in providing entertainment John Buehler
- Noncombat(and combat) skills WAS: (no subject) "Arnau Rossell=?US-ASCII?Q?=F3?= Castell=?US-ASCII?Q?=F3?="< arocas@alumni.uv.es>
- Mountaineering and Athletics Brandon J. Van Every
- Mountaineering and Athletics Damion Schubert
- Mountaineering and Athletics John Buehler
- Mountaineering and Athletics Poe, Lawrence
- Mountaineering and Athletics Vincent Archer
- Noncombat(and combat) skills Jo Dillon
- Noncombat(and combat) skills "Arnau Rossell=?US-ASCII?Q?=F3?= Castell=?US-ASCII?Q?=F3?="< arocas@alumni.uv.es>
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Jack Britt
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Brandon J. Van Every
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Artovil
- They fight! And bite! They fight and bite and fight! Fight fight fight! Bite bite bite! Zach Collins {Siege}
- What Ever Happened to Imaginary Realities? Phillip Lenhardt
- What Ever Happened to Imaginary Realities? Richard A. Bartle
- Butterfly.net Matt Mihaly
- Butterfly.net Freeman, Jeff
- Butterfly.net Luca Girardo
- Butterfly.net Luca Girardo
- Mythology Articles Shannon Appelcline
- Item handling (was: Advertising Thread) Jeff Lindsey
- Advertising Thread Brad McQuaid
- Advertising Thread Brandon J. Van Every
- Advertising Thread Damion Schubert
- Advertising Thread Marc Bowden
- Advertising Thread Damion Schubert
- Advertising Thread Richard Aihoshi aka Jonric
- Advertising Thread Russ Whiteman
- Advertising Thread Brad McQuaid
- Advertising Thread Dave Rickey
- Advertising Thread Marc LaFleur
- Advertising Thread Koster, Raph
- Advertising Thread Marc LaFleur
- Advertising Thread Koster, Raph
- Advertising Thread Richard Aihoshi aka Jonric
- Advertising Thread Zach Collins {Siege}
- Advertising Thread Ron Gabbard
- Advertising Thread Richard Aihoshi aka Jonric
- Social Networks Dave Rickey
- Social Networks Brian 'Psychochild' Green
- Social Networks Dave Rickey
- Social Networks Brian 'Psychochild' Green
- Social Networks Bruce Mitchener
- Social Networks Harrok
- Social Networks Freeman, Jeff
- Social Networks Sage
- Social Networks Damion Schubert
- Social Networks Matt Mihaly
- Social Networks Harrok
- Social Networks Matt Mihaly
- Social Networks Tess Snider
- Social Networks Paul Schwanz
- Social Networks Bruce Mitchener
- Social Networks Paul Schwanz
- Social Networks Michael Tresca
- Social Networks Marian Griffith
- Social Networks Zach Collins {Siege}
- Social Networks Freeman, Jeff
- Social Networks Koster, Raph
- Social Networks Dave Rickey
- Social Networks Sasha Hart
- Social Networks Dave Rickey
- Social Networks Koster, Raph
- Social Networks Dave Rickey
- Social Networks Koster, Raph
- Social Networks Dave Rickey
- Social Networks Freeman, Jeff
- Social Networks Jeff Cole
- Social Networks Koster, Raph
- Social Networks Jeff Cole
- Social Networks Matthew Dobervich
- Social Networks Jeff Cole
- Social Networks Dave Rickey
- Social Networks Jeff Cole
- Social Networks Sasha Hart
- Social Networks Nicolai Hansen
- Social Networks Dave Rickey
- Social Networks Paul E. Schwanz, II
- Social Networks Sasha Hart
- Social Networks paul.schwanz@sun.com
- Social Networks Sasha Hart
- Social Networks Matt Mihaly
- Social Networks John Buehler
- Advertising Thread Edward Glowacki
- Advertising Thread Matt Mihaly
- Histories and Legends paul.schwanz@sun.com
- Histories and Legends Koster, Raph
- Histories and Legends Paul Schwanz
- Histories and Legends Matt Mihaly
- Histories and Legends Paul Schwanz
- Histories and Legends Val Trullinger
- Histories and Legends apollyon
- Histories and Legends Matthew Dobervich
- Histories and Legends Koster, Raph
- Histories and Legends Edward Glowacki
- Histories and Legends Sasha Hart
- Advertising Thread Richard A. Bartle
- Where do you get you numbers? NetEngels@aol.com
- Where do you get you numbers? Dave Rickey
- Mud Advertising Matt Mihaly
- Mud Advertising Christopher Allen
- Mud Advertising Brian 'Psychochild' Green
- Online World Timeline slashdotted Koster, Raph
- Online World Timeline slashdotted Lars Duening
- Online World Timeline slashdotted Dave Rickey
- Online World Timeline slashdotted Ted L. Chen
- Online World Timeline slashdotted Russ Whiteman
- Online World Timeline slashdotted Jon A. Lambert
- TECH: Trusting Network Clients Fox McCloud
- TECH: Trusting Network Clients "Arnau Rossell=?US-ASCII?Q?=F3?= Castell=?US-ASCII?Q?=F3?="< arocas@alumni.uv.es>
- TECH: Trusting Network Clients Jeremy Noetzelman
- TECH: Trusting Network Clients Nicolai Hansen
- TECH: Trusting Network Clients Crosbie Fitch
- TECH: Trusting Network Clients Freeman, Jeff
- TECH: Trusting Network Clients Vincent Archer
- TECH: Trusting Network Clients Brack, J. Allen
- TECH: Trusting Network Clients Kwon J. Ekstrom
- TECH: Trusting Network Clients brian hook
- TECH: Trusting Network Clients Crosbie Fitch
- TECH: Trusting Network Clients Koster, Raph
- TECH: Trusting Network Clients Sasha Hart
- TECH: Trusting Network Clients Phillip Lenhardt
- TECH: Trusting Network Clients Sasha Hart
- TECH: Trusting Network Clients apollyon
- TECH: Trusting Network Clients Travis Nixon
- TECH: Trusting Network Clients Sean Kelly
- TECH: Trusting Network Clients Koster, Raph
- TECH: Trusting Network Clients Sean Kelly
- TECH: Trusting Network Clients Paul Schwanz
- TECH: Trusting Network Clients Justin Quimby
- TECH: Trusting Network Clients Steve Dieter
- TECH: Trusting Network Clients Jesus Lopez
- TECH: Trusting Network Clients Nicolai Hansen
- TECH: Trusting Network Clients Tess Snider
- TECH: Trusting Network Clients Crosbie Fitch
- TECH: Trusting Network Clients Christohe Badoit
- TECH: Trusting Network Clients Bruce Mitchener
- TECH: Trusting Network Clients Christophe Badoit
- TECH: Trusting Network Clients Fox McCloud
- TECH: Trusting Network Clients Christophe Badoit
- TECH: Trusting Network Clients Edward Glowacki
- TECH: Trusting Network Clients James Ross Nicoll
- TECH: Trusting Network Clients Phillip Lenhardt
- TECH: Trusting Network Clients Russ Whiteman
- TECH: Trusting Network Clients Ian Macintosh
- TECH: Trusting Network Clients damon baker
- TECH: Trusting Network Clients Benjamin Tolputt
- TECH: Trusting Network Clients David H. Loeser Jr.
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Koster, Raph
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Dave Rickey
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Dave Rickey
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Crosbie Fitch
- Natural Selection and Communities Koster, Raph
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Dave Trump
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities John Buehler
- Natural Selection and Communities Damion Schubert
- Natural Selection and Communities Ron Gabbard
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Matt Mihaly
- Natural Selection and Communities David Kennerly
- Natural Selection and Communities Paul Schwanz
- Natural Selection and Communities Paul Schwanz
- Peer-to-peer hosting of player created content in persistant worlds. Matthew Dobervich
- Sales data Richard A. Bartle
- Sales data Daniel.Harman@barclayscapital.com
- Sales data Luca Girardo
- Sales data Richard A. Bartle
- Sales data Rayzam
- Sales data Robert A. Rice, Jr.
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Sean Kelly
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Sean Kelly
- Cans of Achievements and Quests Sasha Hart
- Cans of Achievements and Quests Sean Kelly
- Cans of Achievements and Quests Sasha Hart
- Cans of Achievements and Quests Justin Quimby
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Paul Schwanz
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests damon baker
- Cans of Achievements and Quests Rayzam
- Cans of Achievements and Quests Michael Tresca
- Cans of Achievements and Quests Rayzam
- Muds and High School Textbooks Jon A. Lambert
- Unruly Players (fwd) J C Lawrence