Twilight Forums

Idle chat for wannabe heroes
It is currently Tue Sep 02, 2014 7:17 am

All times are UTC - 7 hours




Post new topic Reply to topic  [ 12 posts ] 
Author Message
 Post subject: db optimization
PostPosted: Sat Nov 20, 2010 11:38 am 
Offline
Site Admin
User avatar

Joined: Thu Apr 05, 2007 2:04 pm
Posts: 4265
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.


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Sat Nov 20, 2010 11:49 am 
Offline
Site Admin
User avatar

Joined: Thu Apr 05, 2007 2:04 pm
Posts: 4265
Initial reports are that emptying deep storage has significantly improved speed, so this may actually be working.


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Sat Nov 20, 2010 1:29 pm 
Offline

Joined: Tue May 12, 2009 12:29 am
Posts: 331
Location: I'm on a boat!!!
I don't know if this related, but using *ouch items is noticeably faster.

_________________
Kinak wrote:
Curse you its and it's! Curse yoooooooooou!


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Sat Nov 20, 2010 9:16 pm 
Offline
Site Admin
User avatar

Joined: Thu Apr 05, 2007 2:04 pm
Posts: 4265
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.


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Sat Nov 20, 2010 9:44 pm 
Offline
User avatar

Joined: Sun Apr 08, 2007 1:01 am
Posts: 4549
Location: the Conservatory with the lead pipe
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"


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Mon Nov 22, 2010 12:14 pm 
Offline

Joined: Tue Nov 06, 2007 6:44 am
Posts: 284
Yeah, it's much quicker! GJ Ryme.

_________________
Image
Buying Stainless steelbreaker, n-barrelled shotgun and Seppia's cephalopod skullcap. Pm me here or ingame!


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Mon Nov 22, 2010 12:46 pm 
Offline

Joined: Mon Nov 03, 2008 12:54 am
Posts: 732
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.


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Tue Nov 23, 2010 2:43 am 
Offline

Joined: Tue Nov 06, 2007 6:44 am
Posts: 284
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!


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Tue Nov 23, 2010 11:20 pm 
Offline

Joined: Tue Apr 10, 2007 11:59 am
Posts: 21
Holy crap.

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


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Wed Nov 24, 2010 7:56 pm 
Offline
User avatar

Joined: Mon Dec 17, 2007 8:24 pm
Posts: 1234
Location: Baton Rouge, LA
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"


Top
 Profile  
 
 Post subject: Re: db optimization
PostPosted: Wed Nov 24, 2010 11:28 pm 
Offline
User avatar

Joined: Sun Sep 09, 2007 12:41 am
Posts: 433
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)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 

All times are UTC - 7 hours


Who is online

Users browsing this forum: Google [Bot] and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group