Re: [Sqlgrey-users] Suggestion: Comment field for net_whitelist

[David R. <dr...@gr...>]

Lionel Bouton wrote, On 11/17/2004 1:50 AM:
> 
> I'm in the process of obsoleting this table by creating a lookup file 
> which will allow both IP and fqdn whitelisting. Adding a comment will be 
> simple to do. You'll have something like :
> 132.4.5.6 # This mailserver never retries (it handles domain aaa)
> 196.54.3 # For a single message several servers in this class C can 
> retry (domain a.com, b.org and c.net)
> 
> I'm doing this because it's simpler for people to use files for 
> configuration and net_whitelist is only supported with PostgreSQL.

OK, that'll work.

> - only a primary key (which creates an index implicitly) for other 
> tables. An index on the timestamp could help the cleanup of these 
> tables, all other operations are speed up by the primary key index.

Ah I forgot about the implicit index created by the primary key.

> I'm not yet considering adding indexes to the connect table (I've a 
> problem with MySQL on this one and I've no performance problem with it 
> reported). But adding an index on the timestamps of from_awl and 
> domain_awl is on my TODO list. In the 1.3.x devel releases I've added on 
> the fly database schema conversion support, so when 1.4.0 is out you'll 
> have indexes on timestamps added automatically.

Awesome!

-Dave