improved database speed
BotB Academy Bug Reports and Feature Requests
 
 
73240
Level 29 Hostist
puke7
 
 
 
You might have noticed that the site is loading pages must faster. Thanks to my new jorb, and overhearing folks argue about how to use a database for weeks, I learned about index keys. They are super easy to apply and they make finding things against common values super fast! Holy shizz I are teh n00bsoz!!

So, instead of bumping the MySQL error thread with the huge ugly title, I made this new thread. If anyone sees the my-squeel errors please let me know here. I'm really curious if this optimization killed that problem too!
 
 
73241
Level 10 Mixist
RatShack
 
 
post #73241 :: 2016.10.13 3:12pm
  
  sleeparrow and ViLXDRYAD liēkd this
It blew my mind when I learned about indexes in MSSQL. Saw things like stored procedure execution times drop from 3 seconds to 50 ms. Good jorb.
 
 
73242
Level 19 Chipist
Modus Ponens
 
 
 
post #73242 :: 2016.10.13 3:17pm
  
  ViLXDRYAD liēkd this
Yes! puke, this is great. The site is loading WAY faster now. Thank you for these improvements.
 
 
73248
Level 22 Chipist
m9m
 
 
 
post #73248 :: 2016.10.14 1:00am
  
  ViLXDRYAD liēkd this
botb seems to load much faster for me also. that's really cool!
 
 
73256
Level 28 Chipist
gotoandplay
 
 
 
post #73256 :: 2016.10.14 8:11am
  
  Dimeback, Savestate, m9m, Modus Ponens, Jangler, puke7 and ViLXDRYAD liēkd this
this is cool. i feel like this announcement needs one of those videos that runs a bit like a late 90s broadband ad, going way OTT on the visualisations of higher speed
 
 

LOGIN or REGISTER to add your own comments!