Re: [pmacct-discussion] reloading config & accuracy

[Wim Kerkhoff]

On 9/25/2009 4:03 PM, Aaron Glenn wrote:
On Fri, Sep 25, 2009 at 4:59 AM, Tony<td_mi...@yahoo.com>  wrote:
   
Is there a way to sort it properly by IP address (so that .2 comes after .1) in 
either an SQL query or in an XLS sheet ?

     
I hesitate to be 'that guy' but, you should look at using PostgreSQL.
I don't know enough about MySQL to make any suggestions specific to
it.

   

I totally agree; PostgreSQL handles network data types much better then 
MySQL. It will maintain proper index of the netdata data types.

You can do some sorting in MySQL based on IP:

http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton

But this will not use any of the indexes I believe.

Wim

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists