I'm working on a ver that would support 100,000 users. The
advantage I have is that a given user's login information is
pulled from the database when they log in rather than having
to (a) search through text files looking or (b) cache all users
data when boot.
Sure, putting the maps, items, etc. in the database hasn't
given me much advantage, but I can generate SQL queries
when I want to get an overall "feel" of the current structure.
-----Original Message-----
From: Chuck Carson [SMTP:chuck@EDEN.COM]
Sent: Sunday, May 10, 1998 7:36 PM
To: CIRCLE@post.queensu.ca
Subject: Re: Circle & SQL (not password limit)
In my opinion, this takes away from the simplicity of
building and editing the worlds. You also have to
think about how the files are read and all the checks
for the right types of data in the right places. This would
get rather ugly in a RDB. Also, for something that is only
used at bootup I believe this would be a grand waste of
time and also make debugging another issue entirely.
I could see how maybe creating an access database to
store a world and somehow hacking out a report that
produces a wld/obj/mob/zon/shp file. This way any data
entered into the form can be checked from the start and
that way you know your output file is correct.
I like to jack with RDB's and have given much thought
about how to use one with a mud myself but could see
no benefit from doing so.
my 2 cents,
Chuck
-----Original Message-----
From: Brian Roche <brianroche@EARTHLINK.NET>
To: CIRCLE@post.queensu.ca <CIRCLE@post.queensu.ca>
Date: Sunday, May 10, 1998 7:04 PM
Subject: Circle & SQL (not password limit)
>I'd like to bring up the original question of
>creating a mud using a relational database. How
>plausible would this be? I'm sure all the areas,
>players, mobs, and objects could be stored in
>tables. The player table could have a foreign key
>showing which room the player is located in and
>which objects the player is wearing or has in
>inventory. What are everybody's thoughts on this?
>
>--
>Brian A. Roche
>brianroche@earthlink.net
>
>
> +------------------------------------------------------------+
> | Ensure that you have read the CircleMUD Mailing List FAQ: |
> | http://democracy.queensu.ca/~fletcher/Circle/list-faq.html |
> +------------------------------------------------------------+
+------------------------------------------------------------+
| Ensure that you have read the CircleMUD Mailing List FAQ: |
| http://democracy.queensu.ca/~fletcher/Circle/list-faq.html |
+------------------------------------------------------------+
+------------------------------------------------------------+
| Ensure that you have read the CircleMUD Mailing List FAQ: |
| http://democracy.queensu.ca/~fletcher/Circle/list-faq.html |
+------------------------------------------------------------+
This archive was generated by hypermail 2b30 : 12/15/00 PST