Page MenuHomePhabricator

Track property data types in a database table.
Closed, ResolvedPublic

Description

In order to determine the data type of a property, we currently need to load the full content of the property. This is presently done not only for every property, but for every value of every property - this can get quite slow for pages that contain hundreds of statements.

It seems sensible to just cache the data types of all properties in memory, just like TermPropertyLabelResolved does this for the labels of properties. In order to do this, we need a way to quickly list all properties along with their type, so we can initialize/update the cache.

Implementing this is expected to provide a considerable performance boost especially for pages containing a lot of entities.


Version: unspecified
Severity: enhancement

Details

Reference
bz49742

Event Timeline

bzimport raised the priority of this task from to Unbreak Now!.Nov 22 2014, 2:01 AM
bzimport set Reference to bz49742.
bzimport added a subscriber: Unknown Object (MLST).

Change 71333 had a related patch set uploaded by Daniel Kinzler:
(bug 49742) introducing PropertyInfoTable.

https://gerrit.wikimedia.org/r/71333

Change 71336 had a related patch set uploaded by Daniel Kinzler:
(bug 49742) Rebuild script for property info table.

https://gerrit.wikimedia.org/r/71336

Change 71339 had a related patch set uploaded by Daniel Kinzler:
(bug 49742) Adding caching layer for property info.

https://gerrit.wikimedia.org/r/71339

Change 71341 had a related patch set uploaded by Daniel Kinzler:
(bug 49742) Introducing PropertyInfoDataTypeLookup

https://gerrit.wikimedia.org/r/71341

Change 71343 had a related patch set uploaded by Daniel Kinzler:
(bug 49742) Hook PropertyInfoStore in service reg.

https://gerrit.wikimedia.org/r/71343

Change 71333 merged by jenkins-bot:
(bug 49742) introducing PropertyInfoTable.

https://gerrit.wikimedia.org/r/71333

Change 71339 merged by jenkins-bot:
(bug 49742) Adding caching layer for property info.

https://gerrit.wikimedia.org/r/71339

Change 71341 merged by jenkins-bot:
(bug 49742) Introducing PropertyInfoDataTypeLookup

https://gerrit.wikimedia.org/r/71341

Change 71336 merged by jenkins-bot:
(bug 49742) Rebuild script for property info table.

https://gerrit.wikimedia.org/r/71336

Change 71343 merged by jenkins-bot:
(bug 49742) Hook PropertyInfoStore in service reg.

https://gerrit.wikimedia.org/r/71343

Verified in Wikidata demo time July 17th