Top Mud Sites Forum Return to TopMudSites.com
Go Back   Top Mud Sites Forum > Mud Development and Administration > Advanced MUD Concepts
Click here to Register

Reply
 
Thread Tools
Old 09-24-2005, 02:25 AM   #1
rotm_adm
Member
 
Join Date: Nov 2004
Location: Waycross, GA USA
Posts: 45
rotm_adm is on a distinguished road
Unhappy

Currently, I run an LPMud using the LDMud driver along w/ the MySQL database package interface. Currently we have taken several parts of our hardcoded inherits and variable formulas and created an assortment of daemons that call our MySQL database stored variables.

At last count, we found that with the conversion from hardcode to a database-driven system w/ daemons, we have saved several megabytes of disk space. An example of the savings can be seen in our player advancement system: Old code -- 8mb via multiple inherits files and variable formulas; New code -- 24.4k daemon file + 3.1k database variables.

Has anyone else utilized the MySQL database (or other databases for that matter) for making their game run better, faster or a little bit of both -- not only for the player's sake, but for your builders/developers as well?

-- Silverthorn
rotm_adm is offline   Reply With Quote
Old 09-24-2005, 03:01 AM   #2
Brody
Moderator
 
Brody's Avatar
 
Join Date: Apr 2002
Location: North Carolina
Home MUD: OtherSpace
Posts: 1,599
Brody will become famous soon enoughBrody will become famous soon enough
Send a message via Skype™ to Brody
Smile

I've been tinkering with this, actually, on one of my side projects. It's quite handy from a resource management standpoint. However, the major drawback can come if your game is on a shared server with other games and websites, with the increased chance for Apache and other SQL-linked goodies to go offline, thus leaving your SQL-driven systems in the lurch.

Not really much of an issue if your game is on a dedicated server, however.
Brody is offline   Reply With Quote
Old 09-24-2005, 10:54 AM   #3
Tezcatlipoca
Member
 
Join Date: Feb 2003
Posts: 46
Tezcatlipoca is an unknown quantity at this point
We're utilizing a Database backend for the store of just about all our mud information (excepting of some code constants that really shouldn't be in it).
Essentially we did it for organization purposes, decreased coding time of save/loads, and for the dynamic nature it lends to our system. Restricted remote access to the system allows for the creation of non-in-game OLC creation building to be done through a separate program, which can access the database for things such as lists of mob and item, templates room types ect. It can also be used to access information about the game quickly and easily for posting on a website, and could be updated instantly upon a chance in the information (pending a refresh of the window of course) (game statistics, help files, ect).

For a large server application which we thought should be as dynamic as possible, it seemed to be the best option. And we're not without help when it comes to needing to do things that a file system could do (distribute the information in the database via file, or back up the system). All that is, obviously, very easily done.
Tezcatlipoca is offline   Reply With Quote
Old 10-29-2005, 12:40 PM   #4
Alexander Tau
Member
 
Join Date: Apr 2002
Posts: 101
Alexander Tau is on a distinguished road
Interesting approach, I have been wondering what sort of database addition I could add to my new project.

I just kicked off a new DGD/Phantasmal Mud that is going to be set in Space. And not just any old Space but one with 100,000 Stars, and about 100,000 Planets.

So naturally I am concerned about storeing and handling a large amount of data.

How much work went into setting up your system. And did you consider any other approaches before you chose the one you did?


A.T
(-)
Alexander Tau is offline   Reply With Quote
Old 10-29-2005, 01:10 PM   #5
the_logos
Moderator
 
the_logos's Avatar
 
Join Date: Sep 2002
Location: Mill Valley, California
Posts: 2,299
the_logos will become famous soon enough
Quote:
Originally Posted by (rotm_adm @ Sep. 24 2005,03:25)
Has anyone else utilized the MySQL database (or other databases for that matter) for making their game run better, faster or a little bit of both -- not only for the player's sake, but for your builders/developers as well?
We use MySQL databases, but definitely not to make the game run faster. They are a lot slower than Rapture's native databases due to the fact that Rapture's dbs are memory resident and are built to sacrifice memory space for the sake of speed. RAM is dirt-cheap, after all, so who cares.

What we use them for, however, is storing data that we need to expose to processes outside the game or data that just doesn't need to be accessed frequently (registration data, player-written books, etc).

--matt
the_logos is offline   Reply With Quote
Reply


Thread Tools


Game Dynamics: Utilizing external databases - Similar Threads
Thread Thread Starter Forum Replies Last Post
MUD game Dianii Newbie Help 5 03-10-2006 02:27 AM
Looking For a Game Wik Advertising for Players 28 06-29-2005 09:47 PM
A new game to try out Ivalaine Tavern of the Blue Hand 0 07-24-2004 03:26 AM
The Name Game Loremaster Advertising for Players 7 01-12-2003 03:00 PM
Question on Dynamics (Pssst KaVir?) Jazuela Advanced MUD Concepts 13 07-16-2002 09:20 PM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT -4. The time now is 09:13 AM.


Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Style based on a design by Essilor
Copyright Top Mud Sites.com 2014