Last modified: 2014-09-30 16:48:03 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T72775, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 70775 - Admin script is really slow now that there are lots of reports
Admin script is really slow now that there are lots of reports
Status: RESOLVED FIXED
Product: Analytics
Classification: Unclassified
Wikimetrics (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Dan Andreescu
u=AnalyticsEng c=EEVS p=0 s=2014-09-18
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-09-12 17:10 UTC by Dan Andreescu
Modified: 2014-09-30 16:48 UTC (History)
7 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Dan Andreescu 2014-09-12 17:10:09 UTC
Problem is when it checks for existing reports - because it matches by name.  It should match by recurrent == 1 as well, and we should have this index on recurrent:

create index ix_report_recurrent on report (recurrent DESC);
Comment 1 Gerrit Notification Bot 2014-09-12 17:29:08 UTC
Change 160031 had a related patch set uploaded by Milimetric:
Speed up admin script by adding an index

https://gerrit.wikimedia.org/r/160031
Comment 2 Gerrit Notification Bot 2014-09-24 22:42:22 UTC
Change 160031 merged by jenkins-bot:
Speed up admin script by adding an index

https://gerrit.wikimedia.org/r/160031

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


Navigation
Links