Bug 6597 - Comments table should have an index on parent_id
Comments table should have an index on parent_id
Status: RESOLVED FIXED
Product: OJS
Classification: Unclassified
Component: General
2.3.5
All All
: P3 normal
Assigned To: PKP Support
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-04-14 11:48 PDT by Alec Smecher
Modified: 2011-04-14 12:00 PDT (History)
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

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);