db optimization

Talk about the game. What game? The game with the power? What power? The power of ... aw, skip it.

Moderator: Moderators

User avatar
Ryme
Site Admin
Posts: 4288
Joined: Thu Apr 05, 2007 2:04 pm
Contact:

db optimization

Postby Ryme » Sat Nov 20, 2010 11:38 am

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.

User avatar
Ryme
Site Admin
Posts: 4288
Joined: Thu Apr 05, 2007 2:04 pm
Contact:

Re: db optimization

Postby Ryme » Sat Nov 20, 2010 11:49 am

Initial reports are that emptying deep storage has significantly improved speed, so this may actually be working.

Sanjuro
Posts: 494
Joined: Tue May 12, 2009 12:29 am
Location: I'm on a boat!!!
Contact:

Re: db optimization

Postby Sanjuro » Sat Nov 20, 2010 1:29 pm

I don't know if this related, but using *ouch items is noticeably faster.
Kinak wrote:Curse you its and it's! Curse yoooooooooou!

User avatar
Ryme
Site Admin
Posts: 4288
Joined: Thu Apr 05, 2007 2:04 pm
Contact:

Re: db optimization

Postby Ryme » Sat Nov 20, 2010 9:16 pm

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.

User avatar
Cristiona
Posts: 4831
Joined: Sun Apr 08, 2007 1:01 am
Location: the Conservatory with the lead pipe
Contact:

Re: db optimization

Postby Cristiona » Sat Nov 20, 2010 9:44 pm

Omigawd.

Emptying storage took, like, 3 seconds! Wow!
Image
The churches are empty / The priest has gone home / And we are left standing / Together alone
--October Project: "Dark Time"

Strlikecrazy
Posts: 284
Joined: Tue Nov 06, 2007 6:44 am
Contact:

Re: db optimization

Postby Strlikecrazy » Mon Nov 22, 2010 12:14 pm

Yeah, it's much quicker! GJ Ryme.
Image
Buying Stainless steelbreaker, n-barrelled shotgun and Seppia's cephalopod skullcap. Pm me here or ingame!

Muhandes
Posts: 732
Joined: Mon Nov 03, 2008 12:54 am
Contact:

Re: db optimization

Postby Muhandes » Mon Nov 22, 2010 12:46 pm

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.

Strlikecrazy
Posts: 284
Joined: Tue Nov 06, 2007 6:44 am
Contact:

Re: db optimization

Postby Strlikecrazy » Tue Nov 23, 2010 2:43 am

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? :D
Image
Buying Stainless steelbreaker, n-barrelled shotgun and Seppia's cephalopod skullcap. Pm me here or ingame!

Jick
Posts: 21
Joined: Tue Apr 10, 2007 11:59 am
Contact:

Re: db optimization

Postby Jick » Tue Nov 23, 2010 11:20 pm

Holy crap.

Do you mind going into some detail about what you did?

User avatar
Corrupt Shadow
Posts: 1234
Joined: Mon Dec 17, 2007 8:24 pm
Location: Baton Rouge, LA
Contact:

Re: db optimization

Postby Corrupt Shadow » Wed Nov 24, 2010 7:56 pm

He installed dBase Optimizer v2.1.5.6

*Please note that this software does not really exist. This post was made in fun.
Image
I've won the 100k DD bet so many times, I should have the title "Mr. Luck"

User avatar
Jesus
Posts: 433
Joined: Sun Sep 09, 2007 12:41 am
Contact:

Re: db optimization

Postby Jesus » Wed Nov 24, 2010 11:28 pm

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? :D

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.
Jesus (#229) | Solitude (#257)


Return to “Gameplay & Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest