Re: [Sqlgrey-users] [SPAM] Re: [SPAM] Re: Patches for SQLgrey

[Lionel B. <lio...@bo...>]

Karl O. Pinc a écrit, le 08/20/2009 04:55 PM :
> On 08/20/2009 08:48:30 AM, Lionel Bouton wrote:
>
>   
>> I discouraged elaborate matchers for a reason : they are slow.
>> If you use full IP or class-c, you are looking up a hash entry. If 
>> you
>> do regex or prefix-based matching, this can become a full sequential
>> search on a list and this part of the code is hit on each and every
>> mail
>> so it better be fast.
>>     
>
> FWIW, PostgreSQL has network data types and functions
> and operators that support/detect subnet mebership etc.
>
> Probably means a separate code path....
>   

I know, a very early SQLgrey version supported them and I dropped this
to support MySQL and SQLite.

Lionel