[Sqlgrey-users] Resolution of my DB problem

[Chris H. <ch...@me...>]

Indexing the connect table's ip_addr field was a good lead to solving my =
performance issue.  But it actually took a little bit more then that.  =
And that might be because I'm in a somewhat different situation than =
many - in that I have a pretty limited range of sender IP addresses.  My =
MX record for our domain actually points to a server running MXLogic's =
spam filtering service.  All our mail traffic first passes through their =
servers, then their servers forward it to my internal filtering box, =
which is where I have SQLGrey installed.  Now...that server gets a few =
connections that *don't* connect to the MX listed mail server...but I =
think we can safely assume those are not legitimate mail transfers.  But =
for the most part, as far as sqlgrey can see, our mail originates =
entirely on one of about 15 servers, all on the same class C.

I took your advice and added an index to the ip_addr column, and it did =
help - but only until I got up to about 50K items.  What *does* seem to =
have worked, though, was building an index of the ip_addr, sender_name =
and rcpt columns.  I've been running at over 160K items in the connect =
table with no problems.