2013-12-07, 11:53 AM
Daakun Wrote: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.
Yeesh.
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.
