Last modified: 2014-11-20 09:16:43 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 26394 - Missing Indexes, Inefficient queries and alike (tracking)
Missing Indexes, Inefficient queries and alike (tracking)
Status: NEW
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
: tracking
Depends on: 22744 24479 26393 27938
Blocks: code_quality tracking
  Show dependency treegraph
 
Reported: 2010-12-22 17:04 UTC by Sam Reed (reedy)
Modified: 2014-11-20 09:16 UTC (History)
2 users (show)

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


Attachments

Description Sam Reed (reedy) 2010-12-22 17:04:11 UTC
Ease of tracking this sort of thing
Comment 1 Andre Klapper 2014-07-08 16:26:50 UTC
Reedy: Is anybody actually "tracking" this, seeing four tickets before #30000 as dependencies? 
Missing indexes sounds like "MediaWiki > Database" with "schema-change" keyword, and inefficient queries sounds like "performance" keyword.

What is this tracking bug good for?
Comment 2 Andre Klapper 2014-08-04 00:13:59 UTC
Reedy: Is anybody actually "tracking" this, seeing four tickets before #30000 as dependencies? 
Missing indexes sounds like "MediaWiki > Database" with "schema-change" keyword, and inefficient queries sounds like "performance" keyword.

What is this tracking bug good for?
Comment 3 Bawolff (Brian Wolff) 2014-08-04 00:20:29 UTC
(In reply to Andre Klapper from comment #2)
> Reedy: Is anybody actually "tracking" this, seeing four tickets before
> #30000 as dependencies? 

Not all inefficient queries are equally important. There's probably more than a couple low priority inefficient queries that just aren't triggered very often

> Missing indexes sounds like "MediaWiki > Database" with "schema-change"
> keyword, and inefficient queries sounds like "performance" keyword.

Sure, adding an index is one type of schema change. Arguably this should track a subset of bugs marked as schema change. Adding an index isn't the only way to fix a query, and sometimes its unclear what the best approach is. Additionally schema change bugs include bugs that require a schema change in order to enable, where this is tracking only already existing things which are inefficient due to the current schema.

> What is this tracking bug good for?

Probably about as good as most tracking bugs. Whether or not tracking bugs are useful in general is probably something that could be debated.

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


Navigation
Links