[opendmarc-users] Bug in opendmarc-expire script

[Todd Lyons]

On Thu, Aug 9, 2012 at 10:19 PM, Todd Lyons <tlyons at ivenue.com> wrote:
> Second, looking at indexes, an EXPLAIN shows that it's doing a full table scan:
> There should be an index on the field that is being used in the WHERE:
> ALTER TABLE `requests` ADD KEY `lastsent_idx` (`lastsent`);

Added two more indexes to fix the same issue:
ALTER TABLE messages ADD KEY `date_idx`(`date`);
ALTER TABLE `signatures` ADD KEY `message_idx`(`message`);

...Todd
-- 
The total budget at all receivers for solving senders' problems is $0.
 If you want them to accept your mail and manage it the way you want,
send it the way the spec says to. --John Levine