[klippy]

What's the latency from your game server to your MySQL server? Queries will execute in order (even if they are threaded), and if say the latency is 100ms and you query 30 times on mapchange, that will be 3 seconds of querying in total. You could update all 30 rows in 1 query if you build the query dynamically, and while that is not ideal at all, it's probably better. I really don't know whats the right way to get rid off this limitation.

Anyway I'm just guessing what could be the problem here, I don't know anything about your setup.