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
- database design Hans-Henrik Staerfeldt
On Thursday 19 August 2004 03:13, Lazarus wrote:
> 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?
Yes. If you have a 64 bit file system, MyISAM tables can handle lots
and lots. I have a table of 167 million rows of 12.56 GB and a 3.28
GB index. (not for a MUD but 3D atom data, but it demonstrates
things nicely)... and that was MyISAM not ISAM.. convert your tables
- then get the latest MySQL :-)
> 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.
Don't do that. Just update what changes... Let all item instances
have a unique item identifier, and a parent identifier for the item
heirarchy. Having a nice objecet oriented way of manipulating your
object data will ensure that you only update the objects you need
to. Design your rows with fixed lengths of possible - this helps
alot on updates (then the key index probably dont need updating).
> 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?
You could do that to limit disk access. Its risky, but thats a
priority question. One way could be to both set the dirty bit and
add the object you need to store to an event list, so it will be
scheduled to be saved at a later time (in a few seconds). If you
modify an object that is 'dirty', you just do so. When an update
event is due, you flush the object to the database, and clear the
dirty bit. This way if objects are changed in a number of ways over
a short time, they will only be saved once or twice...
> I suspect that data base design issues like this won't have a lot
> of impact on the type of game I develop (5000 total player files,
> max 50 concurrent players), but would be interested in hearing
> some of the techniques that people who develop MMOG's employ.
- for starters, I would suggest you just try out flushing everything
to the database directly without any delay, and see how it works for
you....
Since youre working with MySQL, i would suggest trying out
DBDesingner4.
--
--Hans-Henrik Stærfeldt
- 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