| daniel added a comment. |
@Ladsgroup That joins is indeed problematic. But it's only used to detect "new" properties, which do not yet have an entry in wb_property_info. It's triggered when --rebuid-all is set to false (the default). There are several options:
#Remove the --rebuid-all option, and always rebuild all property info entries. There shouldn't be that many properties, so why not.
- Load the set of IDs from wb_property_info first, and just skip the known ones in PHP code. A list of a few thousand integers shouldn't be a problem to hold in memory.
- change the join to use CONCAT( 'P', pi_property_id ) = page_title. This will trigger a file sort, but a) the query is only run manually, by a maintenance script and b) the set of data is going to be small.
TASK DETAIL
EMAIL PREFERENCES
To: daniel
Cc: Ladsgroup, Aklapper, hoo, gerritbot, Tobi_WMDE_SW, Zppix, daniel, QZanden, Izno, Wikidata-bugs, aude, Mbch331
Cc: Ladsgroup, Aklapper, hoo, gerritbot, Tobi_WMDE_SW, Zppix, daniel, QZanden, Izno, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
