August 2004
- What is an MMOG? ceo
- MEDIA: .hack//SIGN Japanise animated series Mike Rozak
- MEDIA: .hack//SIGN Japanise animated series
- MEDIA: .hack//SIGN Japanise animated series Otis Viles
- MEDIA: .hack//SIGN Japanise animated series Richard A. Bartle
- MEDIA: .hack//SIGN Japanise animated series Scott Tengelin
- MEDIA: .hack//SIGN Japanise animated series Dana V. Baldwin
- MEDIA: .hack//SIGN Japanise animated series David Kennerly
- MEDIA: .hack//SIGN Japanise animated series Ghilardi Filippo
- MEDIA: .hack//SIGN Japanise animated series Ola Fosheim Grøstad
- MEDIA: .hack//SIGN Japanise animated series zgj22@drexel.edu
- Books on Virtual Worlds Matt Cruikshank
- DGN: Requesting feedback on a "concept document" (somewhat related to Better Combat) Craig Huber
- The Casual-Player Killer: Time? (was MMO Communities) Will Jennings
- The Casual-Player Killer: Time? (was MMO Communities) Amanda Walker
- The Casual-Player Killer: Time? (was MMO Communities) Michael Sellers
- [BIZ] CoH subscribers numbers Ghilardi Filippo
- [DGN] Socialization against the fun [was: MMO Communities] HRose
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Fwd: Cognitively Interesting Combat (was Better Combat) kennerly@finegamedesign.com
- Time debt Stephen McDonald
- Fwd: Cognitively Interesting Combat (was Better Combat) kennerly@finegamedesign.com
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) David Kennerly
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) David Kennerly
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) David Kennerly
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) Paul Schwanz
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) Paolo Piselli
- Cognitively Interesting Combat (was Better Combat) cruise
- Cognitively Interesting Combat (was Better Combat) ceo
- Cognitively Interesting Combat (was Better Combat) ceo
- Cognitively Interesting Combat (was Better Combat) cruise
- Cognitively Interesting Combat (was Better Combat) ceo
- Cognitively Interesting Combat (was Better Combat) cruise
- Cognitively Interesting Combat (was Better Combat) Paul Schwanz
- Cognitively Interesting Combat (was Better Combat) KaVir@t-online.de (Richard Woolcock)
- Cognitively Interesting Combat Derek Larson
- Cognitively Interesting Combat (keyword: archetypes) Eric Random
- Cognitively Interesting Combat (keyword: archetypes) Paolo Piselli
- ADMIN: Effective progress methods for MUD-Dev (was Better Combat (long)) J C Lawrence
- FW: Deriving Self Esteem from one's MMORPGavatar[was:Long-Term Rewards] vladimir cole
- Asynchronous Event Execution & Localizing Brian Lindahl
- database design Lazarus
- database design Hans-Henrik Staerfeldt
- database design Lazarus
- database design
- [DGN] database design Steven King
- database design Erik Bethke
- database design Sean Kelly
On Wed, 18 Aug 2004, Lazarus wrote:
> I am curious how others have choosen to structure your player data
> base with respect to variable count attributes. In particular, I
> am looking at how one would take a standard mud text player file
> and store that information in a sql data base. Most of the single
> occurance fields like player name, level, gold, last logon time
> ... that sort of thing maps fairly well onto a row in a table. It
> is just those things that you can have a variable number of
> entries, like inventory and skill settings, that I start to
> ponder.
The typical implementation would probably be a table containing a
player id, an item id, and perhaps a stack size. An alternate for
fixed-size inventories might be a long string of columns in a player
or inventory table.
> Is storing each item in its own row, indexed by a unique player
> identifier a reasonable solution? What happens when you have
> 100,000 players with 100-200 items each. Can an ISAM data base
> handle it?
Less than a million rows is really nothing in terms of table size,
so I wouldn't worry. Just make sure that the DB schema and the way
DB operations are performed is tuned correctly. Careful use of
indexes and pre-compiled operations like views and stored procedures
can have a tremendous impact on performance. Plus you may want to
consider memory caching, worker threads, etc.
> How bad do 'pfile updates' become when you have to update each of
> the 100-200 items in the ISAM data base every time things change
> with the player inventory.
So you're saying that some operation can potentially affect every
item in a player's inventory? Seems implementation-specific, but
you may be able to fix things with a single query or it may be a
better idea to add some sort of "effect" table linked to the player
where item information is mutated when it's queried rather than
manipulating the DB entries themselved.
> Likewise with skills. Do you store each skill in its own table
> with rows indexed by a unique player identifier? Do you use dirty
> bits to tell "this skill must be updated" to avoid updating the
> entire list?
I'm not quite sure what you're asking. When would an application
need to update all of a player's skills at the same time?
Sean - database design Hans-Henrik Staerfeldt
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death Artur Biesiadowski
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death Vladimir Cole
- PVP and perma-death Vladimir Cole
- PVP and perma-death Artur Biesiadowski
- PVP and perma-death Steven King
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death Steven King
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death Douglas Goodall
- PVP and perma-death HRose
- PVP and perma-death [NEW THEME] After Deployment Tiago Carita
- PVP and perma-death Paul Schwanz
- PVP and perma-death J C Lawrence
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death HRose
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death HRose
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death HRose
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death HRose
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death Koster, Raph
- PVP and perma-death HRose
- PVP and perma-death ceo
- PVP and perma-death Michael Sellers
- PVP and perma-death Matt Mihaly
- PVP and perma-death Douglas Goodall
- PVP and perma-death HRose
- PVP and perma-death Derek Licciardi
- PVP and perma-death HRose
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death J C Lawrence
- PVP and perma-death Ola Fosheim Grøstad
- PVP and perma-death HRose
- PVP and perma-death Michael Sellers
- PVP and perma-death Byron Ellacott
- PVP and perma-death J C Lawrence
- PVP and perma-death Ola Fosheim Grøstad
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] William Leader
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Stephen McDonald
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] David Kennerly
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] J C Lawrence
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] David Kennerly
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Koster, Raph
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] J C Lawrence
- ADMIN: Effective progress methods for MUD-Dev Jim Purbrick
- The Great Scam J C Lawrence
- [MEDIA] Finding an Interesting Middle Path in the RPG J C Lawrence
- [MEDIA] Finding an Interesting Middle Path in the RPG Koster, Raph
- [MEDIA] Finding an Interesting Middle Path in the RPG Douglas Goodall
- [MEDIA] Finding an Interesting Middle Path in the RPG J C Lawrence
- [MEDIA] Finding an Interesting Middle Path in the RPG David Kennerly
- [MEDIA] Finding an Interesting Middle Path in the RPG Megan Fox
- SOC DGN - Spawn locations Matthew Rick
- SOC DGN - Spawn locations Brian Hook
- SOC DGN - Spawn locations ceo
- SOC DGN - Spawn locations Sean Middleditch
- SOC DGN - Spawn locations Paul Schwanz
- SOC DGN - Spawn locations Jason Lai
- SOC DGN - Spawn locations J C Lawrence
- SOC DGN - Spawn locations HRose
- SOC DGN - Spawn locations J C Lawrence
- SOC DGN - Spawn locations Megan Fox
- SOC DGN - Spawn locations J C Lawrence
- SOC DGN - Spawn locations Ola Fosheim Grøstad
- SOC DGN - Spawn locations HRose
- SOC DGN - Spawn locations Brian Miller
- SOC DGN - Spawn locations Michael Sellers
- SOC DGN - Spawn locations Michael Hartman
- SOC DGN - Spawn locations Brian Miller
- SOC DGN - Spawn locations Chris Duesing
- SOC DGN - Spawn locations Douglas Goodall
- SOC DGN - Spawn locations J C Lawrence
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] William Leader
- On balance and reality Ola Fosheim Grøstad
- On balance and reality William Leader
- On balance and reality Koster, Raph
- On balance and reality Ola Fosheim Grøstad
- On balance and reality HRose
- On balance and reality Ola Fosheim Grøstad
- On balance and reality Vladimir Cole
- On balance and reality William Leader
- On balance and reality William Leader
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Koster, Raph
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Gedanken
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Koster, Raph
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] HRose
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Koster, Raph
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Matthew Dobervich
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Mike Rozak
- text based MUD Codebases, which one to pick? mirjam.eladhari@interactiveinstitute.se
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Douglas Goodall
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Steven King
- Casual Crowd vs.Time Rich Crowd [was: Time Debt] Michael Hartman
- Complexity and Accessibility (was: Better Combat (long)) Will Jennings
- SOC DGN: AC like alligiance system Matthew Rick
- SOC DGN: AC like alligiance system Hans-Henrik Staerfeldt
- SOC DGN: AC like alligiance system cruise
- SOC DGN: AC like alligiance system Artur Biesiadowski
- SOC DGN: AC like alligiance system HRose
- "a nicer species" (from today's Chronicle) (fwd) J C Lawrence
- Distributed State Systems Michael Tindal
- Distributed State Systems Davion Kalhen
- Distributed State Systems Michael Tindal
- Distributed State Systems Alex Arnon
- Distributed State Systems Davion Kalhen
- Distributed State Systems Michael Tindal
- Distributed State Systems Alex Arnon
- Distributed State Systems Alex Arnon
- Distributed State Systems Michael Tindal
- Distributed State Systems Bruce Mitchener
- Distributed State Systems Michael Hartman
- Distributed State Systems Michael Tindal
- Distributed State Systems Thomas Tomiczek
- Distributed State Systems Brian Lindahl
- Complexity and Accessibility Ola Fosheim Grøstad
- wherefor in-game artists? Paolo Piselli
- wherefor in-game artists? Richard A. Bartle
- wherefor in-game artists? Sean Howard
- wherefor in-game artists? David Kennerly
- wherefor in-game artists? ceo
- wherefor in-game artists? David Kennerly
- wherefor in-game artists? Richard A. Bartle
- wherefor in-game artists? Paolo Piselli
- wherefor in-game artists? Richard A. Bartle
- wherefor in-game artists? Ola Fosheim Grøstad
- wherefor in-game artists? Richard A. Bartle
- wherefor in-game artists? Ola Fosheim Grøstad
- wherefor in-game artists? Robert Zubek
- wherefor in-game artists? Matt Mihaly
- wherefor in-game artists? Christopher Allen
- wherefor in-game artists? Matt Mihaly
- wherefor in-game artists? Christopher Allen
- wherefor in-game artists? Ola Fosheim Grøstad
- wherefor in-game artists? Douglas Goodall
- wherefor in-game artists? Christopher Allen
- wherefor in-game artists? Ola Fosheim Grøstad
- wherefor in-game artists? Christopher Allen
- wherefor in-game artists? Ola Fosheim Grøstad
- wherefor in-game artists? Koster, Raph
- wherefor in-game artists? Ola Fosheim Grøstad
- wherefor in-game artists? Koster, Raph
- wherefor in-game artists? Douglas Goodall