Page MenuHomePhabricator

access to database table linktarget is slow
Closed, DeclinedPublicBUG REPORT

Description

e.g. on commonswiki_p

SELECT lt_id, lt_namespace, lt_title
FROM linktarget
WHERE lt_title = 'Media_from_WikiDaheim_2026_in_Austria/all';

from quarry takes about 25 seconds, other categories even longer ('Media_from_WikiDaheim_2025_in_Austria/all' -> 137 sec)

chatGPT thinks the linktarget view can be optimized

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
taavi subscribed.

Your query is missing a namespace filter which is required to efficiently query the table by title.

JJMC89 moved this task from Backlog to Wiki replicas on the Data-Services board.