Last modified: 2007-04-17 17:27:44 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 T9916, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 7916 - smw_specialprops.property_id should be indexed
smw_specialprops.property_id should be indexed
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
All All
: Normal normal (vote)
: ---
Assigned To: Markus Krötzsch
http://svn.wikimedia.org/viewvc/media...
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-11-14 11:38 UTC by S Page
Modified: 2007-04-17 17:27 UTC (History)
0 users

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


Attachments

Description S Page 2006-11-14 11:38:35 UTC
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.
Comment 1 Markus Krötzsch 2006-11-15 14:36:04 UTC
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).
Comment 2 Markus Krötzsch 2007-04-17 17:27:44 UTC
A suitable default index was added in SMW0.7alpha.

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


Navigation
Links