Login    Forum    Search    FAQ

Board index » News and Updates




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Decks loading time improved.
 Post Posted: Mon May 09, 2011 10:29 am 
Offline
Lead Developer
User avatar

Joined: Mon Mar 31, 2008 9:55 pm
Posts: 711
Location: Moscow, Russia
I changed DB, so now initial decks loading should be much faster. Please report if it isn't.


Top 
 Profile  
 
 Post subject: Re: Decks loading time improved.
 Post Posted: Mon May 09, 2011 11:39 am 
Offline

Joined: Mon Mar 29, 2010 2:37 am
Posts: 359
I did notice an improvement but was unaware of your change so chalked it up to an uber interwebs boost. Will keep an eye out next load.

_________________
Looking for: Crumbling Alone (2)
Also looking for: Revenant Bishop, Osin Faith Healer, Pilgrim's Cairn, Avenging Angel (2)


Top 
 Profile  
 
 Post subject: Re: Decks loading time improved.
 Post Posted: Sat May 14, 2011 11:23 pm 
Offline
User avatar

Joined: Sat Oct 24, 2009 12:11 pm
Posts: 148
I noticed this. Very nice job. Now can you do the same for army tab? :)

_________________
Image


Top 
 Profile  
 
 Post subject: Re: Decks loading time improved.
 Post Posted: Tue May 17, 2011 5:44 pm 
Offline
The Dark Platypus
User avatar

Joined: Fri Jun 12, 2009 12:48 am
Posts: 945
To satisfy the geeky part of me: How did you go about making this faster?

_________________
Altren wrote:
I agree with Keyser, and that's what I'm planning to implement actually.

|| The Rise of the DCC | Plasmatium Netherious | Tastes Like Chicken | The Astridian Conspiracy ||

Guild -> | Platypus Rising|


Top 
 Profile  
 
 Post subject: Re: Decks loading time improved.
 Post Posted: Fri May 20, 2011 9:21 pm 
Offline
Lead Developer
User avatar

Joined: Mon Mar 31, 2008 9:55 pm
Posts: 711
Location: Moscow, Russia
There is table that contain list of cards for all deck, and it had no index, so every query for cards list was looking through all 500K lines to find all deck's cards. Now it have multi-index, so query just takes required list without reading whole Table.


Top 
 Profile  
 
 Post subject: Re: Decks loading time improved.
 Post Posted: Sat May 21, 2011 1:11 am 
Offline
The Dark Platypus
User avatar

Joined: Fri Jun 12, 2009 12:48 am
Posts: 945
Altren wrote:
There is table that contain list of cards for all deck, and it had no index, so every query for cards list was looking through all 500K lines to find all deck's cards. Now it have multi-index, so query just takes required list without reading whole Table.

you rock =)

_________________
Altren wrote:
I agree with Keyser, and that's what I'm planning to implement actually.

|| The Rise of the DCC | Plasmatium Netherious | Tastes Like Chicken | The Astridian Conspiracy ||

Guild -> | Platypus Rising|


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

Board index » News and Updates


Who is online

Users browsing this forum: No registered users 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
You cannot post attachments in this forum

Search for:
Jump to:  
cron