Page MenuHomePhabricator
Create Task
Maniphest T9916

smw_specialprops.property_id should be indexed
Closed, ResolvedPublic
Actions

Description

Author: info

Description:
All queries of the smw_specialprops table look for a particular kind of property
e.g. SMW_SP_HAS_TYPE, yet property_id is not indexed.

Version: unspecified
Severity: normal
URL: http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/SemanticMediaWiki/specials/SMWAdmin/SMW_SpecialSMWAdmin.php?revision=HEAD&view=markup

Details

Reference
bz7916

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:29 PM
• bzimport added a project: MediaWiki-extensions-Semantic-MediaWiki.
• bzimport set Reference to bz7916.
• bzimport created this task.Nov 14 2006, 11:38 AM
mkroetzsch added a comment.Nov 15 2006, 2:36 PM

True. Since the number of special properties is always limited, one might also
have seperate tables for different types (or collections) of properties right
away. Since both this and the indexing is a change to the DB scheme, I would
prefer to wait with this optimisation until after the next release (which will
not change the DB).

mkroetzsch added a comment.Apr 17 2007, 5:27 PM

A suitable default index was added in SMW0.7alpha.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL