Page 1 of 1
db optimization
Posted: Sat Nov 20, 2010 11:38 am
by Ryme
As a note, I just did a bunch of DB optimization stuff. Ideally things will either be slightly faster or unaffected. If anyone sees errors or thinks things are noticeably worse, please let me know.
This is step 2 of about 8 things I'm going to try to do over the next few weeks to improve performance, which seems to take a bit of a hit right around rollover.
Re: db optimization
Posted: Sat Nov 20, 2010 11:49 am
by Ryme
Initial reports are that emptying deep storage has significantly improved speed, so this may actually be working.
Re: db optimization
Posted: Sat Nov 20, 2010 1:29 pm
by Sanjuro
I don't know if this related, but using *ouch items is noticeably faster.
Re: db optimization
Posted: Sat Nov 20, 2010 9:16 pm
by Ryme
I'm going to assume the earlier one was fine, or we would have seen errors by now.
I made another quick change right at rollover. Please let me know if you see any weird things in the next couple of hours. Slowness or errors, mostly.
Re: db optimization
Posted: Sat Nov 20, 2010 9:44 pm
by Cristiona
Omigawd.
Emptying storage took, like, 3 seconds! Wow!
Re: db optimization
Posted: Mon Nov 22, 2010 12:14 pm
by Strlikecrazy
Yeah, it's much quicker! GJ Ryme.
Re: db optimization
Posted: Mon Nov 22, 2010 12:46 pm
by Muhandes
In Hebrew we call this "Taking the goat out". It involves a long story with a Rabbi and a goat, I'm sure you don't want to hear.
Anyway, GJ, the game really is much faster.
The one thing that really is still way too slow for me is loading pages with tons of images. The obvious is my MD which locks the game for a minutes or two, but also my inventory. I'd love a "no images" option.
Re: db optimization
Posted: Tue Nov 23, 2010 2:43 am
by Strlikecrazy
Muhandes wrote:The one thing that really is still way too slow for me is loading pages with tons of images. The obvious is my MD which locks the game for a minutes or two, but also my inventory. I'd love a "no images" option.
Auto-sell some stuff?
Re: db optimization
Posted: Tue Nov 23, 2010 11:20 pm
by Jick
Holy crap.
Do you mind going into some detail about what you did?
Re: db optimization
Posted: Wed Nov 24, 2010 7:56 pm
by Corrupt Shadow
He installed dBase Optimizer v2.1.5.6
*Please note that this software does not really exist. This post was made in fun.
Re: db optimization
Posted: Wed Nov 24, 2010 11:28 pm
by Jesus
Strlikecrazy wrote:Muhandes wrote:The one thing that really is still way too slow for me is loading pages with tons of images. The obvious is my MD which locks the game for a minutes or two, but also my inventory. I'd love a "no images" option.
Auto-sell some stuff?
Yeah. After every run, I spend a lot of time MDing things for my collection and things that might be useful later on in an all-pull scenario, then Recyclonize most of the other stuff into TNT just to keep the inventory manageable.