How much is to much for DB bloat?

Post Reply
User avatar
Vitello
Member
Posts: 240
Joined: Sun Jan 15, 2012 10:08 am

How much is to much for DB bloat?

Post by 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

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

Re: How much is to much for DB bloat?

Post by 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!

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

Re: How much is to much for DB bloat?

Post by 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.

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

Re: How much is to much for DB bloat?

Post by Rias » Tue May 05, 2015 10:09 pm

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

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

Re: How much is to much for DB bloat?

Post by 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!

Post Reply

Return to “General Discussion”