Top Mud Sites Forum - View Single Post

koteko · 12-02-2012, 03:41 PM

as far as server pricing is concerned, I'm fine with buyvm for the 25$ monthly (it's 20$ if you pay bi-yearly). That means I need to stay into MAXIMUM 2GB overall, even though burst up to 4GB are available. Indeed I'm considering very carefully which optimisation to use.

I have actually thought to use databases, since the offline data is already stored. H2 database seems to be very well performant (especially if embedded in the application, not client-server) and it'd do the caching for me (some of the tables could be completely loaded in memory). I'm just not sure about how good it is with a lot of users issuing a lot of commands and moving around, but I will do some tests with a huge database to see how it does.

Any experience with DBs for MUDs? If I understood correctly also CoffeeMUD uses them, I'm going to check if they do some personalized caching loading rows into objects or something.

12-02-2012, 03:41 PM	#9
koteko New Member Join Date: Mar 2012 Posts: 20	Re: A huge grid world as far as server pricing is concerned, I'm fine with buyvm for the 25$ monthly (it's 20$ if you pay bi-yearly). That means I need to stay into MAXIMUM 2GB overall, even though burst up to 4GB are available. Indeed I'm considering very carefully which optimisation to use. I have actually thought to use databases, since the offline data is already stored. H2 database seems to be very well performant (especially if embedded in the application, not client-server) and it'd do the caching for me (some of the tables could be completely loaded in memory). I'm just not sure about how good it is with a lot of users issuing a lot of commands and moving around, but I will do some tests with a huge database to see how it does. Any experience with DBs for MUDs? If I understood correctly also CoffeeMUD uses them, I'm going to check if they do some personalized caching loading rows into objects or something.