https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7990
John Hardin <jhar...@impsec.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jhar...@impsec.org
--- Comment #2 from John Hardin <jhar...@impsec.org> ---
(In reply to peter gervai from comment #0)
> ... remove the whitelisted addresses, one by one,
> from the table by using:
>
> my $sql = "DELETE FROM $self->{tablename} WHERE username = ? AND email =
> ?";
>
> CREATE INDEX i_txrep_username_email ON txrep (username,email);
>
> reduced the runtime a little bit, to about 3-5 seconds.
"username" is likely less-selective than "email", so you'd probably get even
better results from:
CREATE INDEX i_txrep_email ON txrep (email,username);
--
You are receiving this mail because:
You are the assignee for the bug.
