How much is to much for DB bloat?

Member
Posts: 240
Joined: Sun Jan 15, 2012 10:08 am

How much is to much for DB bloat?

Postby Vitello » Thu Apr 23, 2015 7:51 pm

On other games with crafting like this the database eventually got out of control and so overloaded there was events specificly to destroy massive amounts of items.

I have to admit as an Artisan I keep a rather large stockpile, some shrinks and grows as I use it, but other things have been laying around for months.

So what are some good rules of thumb for keeping stockpiles reasonable?
Vitello - Ton - Shirinya - Alwaren

DEV
User avatar
Posts: 2635
Joined: Sat Apr 14, 2012 12:17 pm

Re: How much is to much for DB bloat?

Postby Jirato » Tue May 05, 2015 7:46 pm

At this point I wouldn't worry about it, if it ever starts to become an issue we can look into non-destructive solutions. I've got a few in mind.

Rooms (and their contents) as well as bank vaults are both stored in plain text json-encoded flatfiles, we don't use a traditional database-driven system like most MUDs.

File access time for rooms isn't much of an issue since they are only loaded at server startup and saved at server shut down or during the daily "roomsaver" event, which y'all may recognize as the 2:00 AM lag spike. :-)

Vaults are read/saved on the fly whenever their relevant verbs are accessed, but again it hasn't been much of an issue thus far.

The only potential thing about having excessive items in janitor-proof rooms that could cause slowdown is when our update loop hits the room and loops through each item to check for various things such as if they're burning, if they're a light source, etc. That particular section of our update loop is rather speedy with the slow part being completely un-related (Critter AI).

So yeah, no worries at the moment.
[GMCHAT Uyoku]: Octum is when the octumbunny comes around and lays pumpkins everywhere right?
[GMCHAT Rias]: Dimmes says "oh hai :) u need healz? ill get u dont worry thaum lasers pew pew pew lol"
[CHAT - GameMaster Rias would totally nuke Rooks]: Here's how elemancy works: The freeblegreeble and the zippoflasm have to be combined with the correct ration of himbleplimp, then you add the gargenheimer and adjust the froopulon for the pattern you want, apply some tarratarrtarr, yibble the wantaban, and let 'er rip!

Member
Posts: 598
Joined: Mon Oct 06, 2014 7:21 pm
Location: Illinois

Re: How much is to much for DB bloat?

Postby Fayne » Tue May 05, 2015 8:02 pm

Gotta love that 2 minute lag every morning.
A scrawny alley cat stares after the dog with big green eyes.
Speaking to a scrawny alley cat, you ask, "Friend of yours?"
A scrawny alley cat hisses angrily.

Lore Hermit
User avatar
Posts: 6038
Joined: Tue Aug 04, 2009 4:23 pm
Location: Utah

Re: How much is to much for DB bloat?

Postby Rias » Tue May 05, 2015 10:09 pm

I want to do the destructive solutions.
The lore compels me!

DEV
User avatar
Posts: 2635
Joined: Sat Apr 14, 2012 12:17 pm

Re: How much is to much for DB bloat?

Postby Jirato » Wed May 06, 2015 4:51 pm

Rias wrote:I want to do the destructive solutions.


Food spoilage!
[GMCHAT Uyoku]: Octum is when the octumbunny comes around and lays pumpkins everywhere right?
[GMCHAT Rias]: Dimmes says "oh hai :) u need healz? ill get u dont worry thaum lasers pew pew pew lol"
[CHAT - GameMaster Rias would totally nuke Rooks]: Here's how elemancy works: The freeblegreeble and the zippoflasm have to be combined with the correct ration of himbleplimp, then you add the gargenheimer and adjust the froopulon for the pattern you want, apply some tarratarrtarr, yibble the wantaban, and let 'er rip!

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests