Open
Bug 526144
Opened 16 years ago
Updated 11 years ago
[MS-SQL] missing multi-field index on longdescs.bug_id, longdescs.bug_when
Categories
(Bugzilla :: Database, defect)
Bugzilla
Database
Tracking
()
ASSIGNED
People
(Reporter: mockodin, Assigned: mockodin)
References
(Blocks 1 open bug)
Details
Attachments
(1 file, 1 obsolete file)
|
643 bytes,
patch
|
mkanat
:
review-
|
Details | Diff | Splinter Review |
longdescs table should have an index on bug_when
Under MSSQL adding this index decreased execution time of show_bug from 6-10 seconds to 1-3 seconds dependent on the number and size of the comments.
Bug_when is used as the 'order by' field when displaying bug comments in show_bugs.cgi via Bugzilla::Bug::GetComments(<bugid>)
|
Assignee | |
Comment 1•16 years ago
|
||
Correction:
should be a multi-field index of bug_id and bug_when
|
|
Assignee | |
Updated•16 years ago
|
Summary: [MSSQL] missing index on longdescs.bug_when → [MSSQL] missing multi-field index on longdescs.bug_id, longdescs.bug_when
|
|
Assignee | |
Comment 2•16 years ago
|
||
|
|
Assignee | |
Comment 3•16 years ago
|
||
corrected index name to include '_idx' suffix
Attachment #409964 -
Attachment is obsolete: true
Attachment #409966 -
Flags: review?(mkanat)
Attachment #409964 -
Flags: review?(mkanat)
|
|
Assignee | |
Updated•16 years ago
|
Summary: [MSSQL] missing multi-field index on longdescs.bug_id, longdescs.bug_when → [MS-SQL] missing multi-field index on longdescs.bug_id, longdescs.bug_when
|
||
Comment 4•16 years ago
|
||
Comment on attachment 409966 [details] [diff] [review]
v1.1
If you really think this needs to exist (and I'm somewhat doubtful?) then it should be part of the existing bug_id index.
Attachment #409966 -
Flags: review?(mkanat) → review-
You need to log in
before you can comment on or make changes to this bug.
Description
•