Last modified: 2014-11-20 09:16:43 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 T28394, the corresponding Phabricator task for complete and up-to-date bug report information.
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