https://bugzilla.wikimedia.org/show_bug.cgi?id=69100

--- Comment #7 from Sam Reed (reedy) <[email protected]> ---
(In reply to Aaron Schulz from comment #3)
> * The query in handleFailingRecipient() is unindexed, how large is the table
> expected to get?

I was about to file a bug about that

I guess it should probably be a partial index on the email field, and then the
timestamp.

Something like:

CREATE INDEX /*i*/br_mail_timestamp ON /*_*/user (br_user_email(50),
br_timestamp);


In core we only index the first 50 chars of the email on the user table

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to