Last modified: 2007-04-17 17:27:44 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.
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).
A suitable default index was added in SMW0.7alpha.