Re: [Sqlgrey-users] Split of from_awl into dsn_awl needed

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

Michael Storz wrote the following on 07.05.2005 00:13 :

>Analyzing our from_awl, I found the following:
>
>The table has 365.208 entries from 178.026 different ip addresses.
>>From these ip addresses
>
>- 129.210 have exactly one entry and this is with sender_domain =
>  "-undef-"
>- 38.904 have only entries without sender_domain = "-undef-"
>- only 9.912 have entries with both kind of sender_domains
>
>If we split the from_awl in 2 tables
>
>- from_awl: sender_domain <> "-undef-"
>- dsn_awl:  sender_domain = "-undef-"
>
>(...)
>  
>

Ok. I consider this a design bug. In the original design from_awl is the
first step towards domain_awl. But DSNs can't go into domain_awl
(obviously because of the lack of domain...). This won't make it in
1.6.0, but it is now in my TODO.

>If we include connect_awl, I don't think we need a split of this table,
>because the backscatter DSNs will propagate fast into the dsn_awl, only
>normal DSNs will stay in connect_awl.
>  
>

This I don't understand. How do we make the difference between
backscatter DSNs and normal DSNs ?

Lionel.