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 (15)
- Cc westi added
- Milestone changed from Awaiting Review to 3.1
comment:12 pento — 5 months ago
- Component changed from Comments to Database
- Keywords 3.2-early removed