[MUD-Dev] Database vs. Disk

[Sulka Haro]

Hi!

You can't know if the solution will work for you until you do some
testing. If you encounter problems during the test, try to get some
more information and/or advice and then do some more testing. If you
still can't make it work, the solution might not be good for you.

Databases are usually designed for storing very large amounts of
data so millions of objects shouldn't be a problem as long as you're
indexing the data properly and aren't exceeding your platform's file
size maximums (if using a DB where table = file).

We're using MySQL (a simple no bells and whistles DB) for storing
tens of millions of objects so at least someone is successfully
using off-the-shelf databases for a (graphical) MUD. And yes, the
added versatility is nice. :) Also at least on Solaris 8, MySQL has
proven out to be _extremely_ reliable.

sulka

_______________________________________________
MUD-Dev mailing list
MUD-Dev at kanga.nu
https://www.kanga.nu/lists/listinfo/mud-dev