10.11.2011, 20:45
Thanks a lot for the explanation, Slice. I wasn't aware of such functions in MySQL and had never before looked into how IP addresses can be integers. For anyone interested, here's an article with some benchmarking on how storing IP addresses can be made more efficient.
This change will make 4 string fields into 2 unsigned integer fields. And the change to the ban checking query which is ran every time a player connects, will improve things even more!
I'll sure look into your code even more and I hope you haven't forgotten your awesome topic about optimizations and enhancements. I'd love to see something new in there!
This change will make 4 string fields into 2 unsigned integer fields. And the change to the ban checking query which is ran every time a player connects, will improve things even more!
I'll sure look into your code even more and I hope you haven't forgotten your awesome topic about optimizations and enhancements. I'd love to see something new in there!