Indexes for comment_author_email and user_id
|Reported by:||tellyworth||Owned by:|
There are currently no indexes on any of the author columns in wp_comments. That means there's no efficient way to count the comments written by a given commenter, for example.
The enclosed patch adds two separate non-unique indexes, one each for comment_author_email and user_id.
Change History (13)
- Cc westi added
- Milestone changed from Awaiting Review to 3.1