Lobby Player API: help me!

[ramirez]

Well, it might not be necessary, I doubt the speed difference is that critical with the amount of servers that the lobby holds. Using two fields isn't necessarily inefficient. For example if you make a numeric IP field (INT UNSIGNED) and a port field (SMALLINT UNSIGNED) and create an unique index on those two, it should be fairly efficient (and that way you don't need to waste the 2 bytes by creating a 8 byte column, not that it's a lot of waste ). Even if the IP is a string, I'm fairly sure it'd scope just fine for the lobby.

[DePhille]

Thanks for lighting that up to me, chrisgbk! Indeed, seems like I've missed the usage of the locking.
I think we're pretty close to a solution here, but I cannot really follow anymore since I rarely get that deep into building SQL statements as proved with my mishap about the locking. I'd have to look up alot of information rather than using experience.

However, keep in mind this isn't google or something. I think it's better to have an easy code rather than winning 0.001 second with it despite my strive for performance. Anyway, that's Brick's choice .

Grtz, DePhille