Rick Widmer wrote:
I wasn't quite ready for this, but it has been on my list for a long
time... since it has come up, let me throw up this database structure
for comment. I have reduced the number of tables (in a full
installation) and made it relational.-
CREATE TABLE relay(
ip_addr char(18) not null,
timestamp datetime,
primary key( ip_addr )
),
No coffee yet so this may well be out in left field, but on large
systems when a clear open smtp is run I don't think you'll want to be
searching through 20K records in the table to see who to expire.
I'd add a key on timestamp.
Rick
