"Only a life lived for others is a life worth while." - Albert Einstein

MapleSEA Ranking Database – 2

Autor duststar

A quick update on progress.

The database design for the ranking database is finally done and tested. Right now, I am working on summarising data. To improve SELECT query performance, all data needs to “summarised” before I insert them into the database e.g. aggregate by day, week, month etc

Let’s look at BOOTES dataset for the past 10 hours! (From 0000 hours to 1000 hours, GMT +8)

1. Congrats to all those who level up (A total of 81 players). Below are the top 10 climbers based on level descending sequence.

IGN Level Gain
Starstarfied 194 1
PiNkLoLLy 193 1
KabutoJR 192 1
BabySunRise 192 1
ohhyaayaa 189 1
PPTED1 189 1
PoorLeng 185 1
Periwlnkle 183 1
MageCl3ric 183 1
OmFgiTzOinky 182 1

2. Top 10 climbers based on levels gained descending sequence.

IGN Level Gain
imaimai 149 3
x3xGuanYu 147 2
xzInfighterz 138 2
Alvinsck 149 2
JoanStarS 138 2
cuti3priest 142 2
AranXruss 140 2
K8510 148 2
PoPCoRnBoiZ 149 2
2HoneyBoy2 167 1

 

Hope you like them and watch out for more coming soon as the project gets nearer to completion!

.duststar

CommentComment

CAPTCHA Image CAPTCHA Audio
Refresh Image

  • Meta

© 2010 duststar theory