Hello,
If you don't query against Wikidata database and
specially wb_items_per_site, please ignore this message.
We recently dropped wb_entity_per_page table and as result some queries had
to change, namely the ones that querying against wb_terms and
wb_items_per_site tables because these two store the entity numeric id
instead of full id (e.g. Q7251 vs. 7251) so when you join against these
tables you need to add concatenation, for example CONCAT("Q", ips_item_id).
This sometimes can have performance implications and force you to rewrite
the whole query in order to obtain desired performance which is not true in
wb_terms table anymore because it now contains both numeric id
(term_entity_id) and the full id (term_full_entity_id). But we haven't done
it for wb_items_per_site table yet.
So the question is, are querying against this table and does using
concatenation caused you performance problems? If your answer is yes,
please raise your voice in phabricator [0]
[0]:
https://phabricator.wikimedia.org/T179928
Best
--
Amir Sarabadani
Software Engineer
Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin
Tel. (030) 219 158 26-0
http://wikimedia.de
Stellen Sie sich eine Welt vor, in der jeder Mensch an der Menge allen
Wissens frei teilhaben kann. Helfen Sie uns dabei!
http://spenden.wikimedia.de/
Wikimedia Deutschland – Gesellschaft zur Förderung Freien Wissens e. V.
Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter
der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für
Körperschaften I Berlin, Steuernummer 27/029/42207.