Bug 6597 – Comments table should have an index on parent_id

Bug 6597 - Comments table should have an index on parent_id

Summary:

Comments table should have an index on parent_id

Status:	RESOLVED FIXED

Product:	OJS
Classification:	Unclassified
Component:	General
Version:	2.3.5
Platform:	All All

Importance:	P3 normal
Assigned To:	PKP Support

URL:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2011-04-14 11:48 PDT by Alec Smecher
Modified:	2011-04-14 12:00 PDT (History)
CC List:	0 users

See Also:
Version Reported In:
Also Affects:

Attachments
Patch against OJS 2.3.4 (445 bytes, patch) 2011-04-14 11:59 PDT, Alec Smecher	Details \| Diff
Patch against OCS 2.3.3-1 (375 bytes, patch) 2011-04-14 11:59 PDT, Alec Smecher	Details \| Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Alec Smecher 2011-04-14 11:48:32 PDT

Comments table should have an index on parent_id.

Comment 1 Alec Smecher 2011-04-14 11:59:11 PDT

Created attachment 3482 [details]
Patch against OJS 2.3.4

Comment 2 Alec Smecher 2011-04-14 11:59:31 PDT

Created attachment 3483 [details]
Patch against OCS 2.3.3-1

Comment 3 Alec Smecher 2011-04-14 12:00:56 PDT

NOTE: These patches will only affect your installation if they are applied *before* the installation or upgrade scripts are run. To add the missing index to an existing installation without running an upgrade, execute the following SQL:

CREATE INDEX comments_parent_comment_id ON comments (parent_comment_id);