Closed Bug 283785 Opened 20 years ago Closed 19 years ago

Sanitycheck.cgi times out on huge sites

Categories

(Bugzilla :: Bugzilla-General, defect)

Product:
Bugzilla
Component:
Bugzilla-General
Version:
2.19.2
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED DUPLICATE of bug 172774

People

(Reporter: bugreport, Unassigned)

Details

The cross-check from attachments.submitter_id to userid does not use an index on
attachments properly and results in webserver timeouts.

This can be solved by either adding an index on 
ALTER TABLE attachments ADD INDEX submitter (submitter_id, bug_id)

or by changing the cross-check to avoid pulling the bug id.
(In reply to comment #0)
> or by changing the cross-check to avoid pulling the bug id.

this has already been proposed in bug 172774.

*** This bug has been marked as a duplicate of 172774 ***
Status: NEW → RESOLVED
Closed: 19 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.