Add an index for cid to the {comment_revisions} table. [#1084516]

The comment_revisions table should have an index on the 'cid' field since there are many queries that use it as a WHERE condition.

Patch forthcoming.

Comment	File	Size	Author
#1	1084516_cid_index.patch	1.01 KB	te-brian

Comments

te-brian commented 8 March 2011 at 00:26

Status	File	Size
new	1084516_cid_index.patch	1.01 KB

Here is the patch.

thinkyhead commented 15 September 2011 at 08:05

Assigned:	Unassigned	» thinkyhead
Status:	Active	» Needs work

Added to my dev tree, so this will be in 1.3.