Hi Paolo and Scott,
Your discussion pointed out an important issue - what is the proper design
when it comes to high frequently IP-based queries?
Inspired by this thread, my idea is to use postgresql and count on its
cidr/inet function. (I am using mysql and store ipv4 as string(15))
Hi guys,
I just wanted to summarize that:
It looks like a fine way to address IPs in a DB seems to be the pgsql way.
Fast, and you can easily select data using subnets without relying on regexp.
While in mysql you either obtain a int value difficult to handle, or a string
very slow to search
These addon looks great in my book. I really do like pmacct but have not had
the chance to implement it other than in testing due the the lack of a good
frontend ( and due to the fact that we lack time to develop one ourself)
Med vänlig hälsning
Andreas Larsen
IP-Only Telecommunication AB|