Re: [pmacct-discussion] Format of storage IP addresses in database.

2009-09-13 Thread Paolo Lucente
Hi Slava, On Wed, Sep 09, 2009 at 09:38:03PM +0300, Slava Dubrovskiy wrote: Why for store IP it is used CHAR type? It's better use INT UNSIGNED and use INET_ATON() and INET_NTOA() for convert. http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton This is

Re: [pmacct-discussion] Traffic count only for certain networks

2009-09-13 Thread Paolo Lucente
Hi Slava, On Thu, Sep 10, 2009 at 02:24:22PM +0300, Slava Dubrovskiy wrote: [ ... ] It is necessary to count the traffic with filtering on certain networks. For this purpose I need write ALL this networks to aggregate_filter. But this list of networks is big and it periodically varies. I