Re: [Exim] Spews list filtering

Not too much of a worry - its only 16000 entries, which isn't much at
all as far as mysql is concerned.

On Wed, 2003-02-12 at 12:45, Nico Erfurth wrote:
> Konrad Michels wrote:
> > Also just implimented your mysql query - it seems to work. Is there any
> > way to get rid of it checking for a mask though? Otherwise I'm going to
> > have to put a lookup statement in for every possible netwmask value!
>
> No one that I'm aware of :-/
>
> Your best bet is to use my script, and modify it a little bit to
> normalize to some fixed values, like
> /16
> /20
> /24
> /28
> /32
>
> This will still increase the needed database space, but should be better
> than inserting every single ip.
>
> Btw, is anyone aware of an "network"-database, that's optimized for such
> queries, where you can say "is 10.2.3.4 in any of your know networks"?
>
> Nico
--
***********************************************************************
*
* Konrad Michels
* System Administrator
* Surfkitchen Limited
* Abbey House
* 1650 Arlington Business Park
* Theale
* RG7 4SA
* United Kingdom
* Tel: +44 118 929 8079
*
***********************************************************************