[wp-hackers] Storing IP's in the DB

Pixline › Paolo Tresso supporto at pixline.net
Thu Apr 30 14:05:30 GMT 2009


Il giorno 30/apr/09, alle ore 15:49, Ozh ha scritto:

> I've read that it's better & faster to store IP as integers instead of
> strings, and then using INET_ATON / INET_NTOA functions to convert
> (the argument being that MySQL is faster with numbers than with
> strings)

I've recently switched a legacy nonWP code to use INET_* and this  
technique, and I'm really satisfied with the results, so +1 on this.

> Any reason why WP is not doing this?

I'd love to see in the next releases a major focus on optimization  
(and something is already going on); this is a minor thing but would  
be really nice.

Paolo/Pixline


More information about the wp-hackers mailing list