Fixing bugs like that takes that long?
Or are there a lot of people to move from Snail Park to Lith Harbor?
at least they're fixing it
I don't know much about database junk, but if it works anything like most search queries it'll have to look at each and every character that exists, compare a map id, and then change that and the respawn point if a match is found.
Taking a while is likely the result of having so many dang characters that need looked at.
Edit: There are approximately 21,486,244 characters, and that's only counting the ones that show up in the rankings.
Hooray, no more Hot Time for me.
They should do a wipe
Most people can run out. It's just the 0.5% of MS or less that is stuck there. Quest fanatics get pulled down under.
They explained at some point that just taking the servers down and bringing them back up again takes about that long.
Not that hard to just add a WHERE clause and make it only search for characters above level 10. Suddenly the results in that query go down to... a lot less.
Doesn't help much if that field is not an index. Also, the 21 million on rankings are all above level 10.
Bingo. Non-indexed queries take exponentially longer than indexed queries.
That's why they're only querying for characters above level 10 that are on a few specific maps (The first few on maple island, which is where my adventurer is stuck at)
Though yes, non-indexed queries would take a loooooot longer. Never seen their database, so I wouldn't know.
After I spend 3 hours trying to get GMS to work I finally have everything set up and this happens. Oh well.
I wonder what's gonna be ninja patch'd this time.
Hoping that they don't "fix" the spawn rate.
I have the horrible feeling that Gollux's body parts will stop dropping green coins again.
"R" Ice Cube or indirectly Love Letters would be my guess, definitely more pressing compared to Gollux Coins which I assume are still limited by the six entrances and further limited to three in observation that Keys either do not drop or drop at a significantly lower rate.
just when I wanted to set up my main for the hot time... ty obama
Just tested it, they still drop.
SO what did they fix/broke?
|Slip's Music Database (GMS v177: The Afterlands)||Maplestory "High Five" Private Showcase||v.177 – Strange Stories Update Preview|
|[KMS]Inkwell Diary # 72 - Night Walker skill preview||[Updated] v.177 – Strange Stories Patch Notes||Rules and Regulations [UPDATED: 2014-09-15]|
|NXPatcher - Create your own pre-patcher & list of Maple FTPs||[Rant] This game's practically dead in terms of actual content.||Onyx Ring Discussion|
|Is NexonNA trying to kill Reboot World?||Maple Memo: A Better Maple Update||Beast Tamer discussion thread|
|RED update thoughts and feedback||Known Issues: Updated August 6, 2015||Maplestory 2, Aanyeong|