Page MenuHomePhabricator

Special:ActiveLanguages should not perform slow queries if results are cached
Closed, ResolvedPublicBUG REPORT

Description

Reported in https://translatewiki.net/wiki/Thread:Support/Saraiki_language_%3F. This message should not happen, as we pre-cache the results. But if one requests data for language with no activity, it will perform a slow database query, as no data has been cached.

The script should be amended so that it does negative caching for a list of languages for which there were no activity. It's hard to get list for "isKnownLanguageTag", so maybe use TranslateUtils::getLanguages instead. The special page should validate input against the same list.

Event Timeline

Nikerabbit renamed this task from Special:ActiveLanguages should not perform slow queries if results are cache to Special:ActiveLanguages should not perform slow queries if results are cached.Sep 13 2021, 8:21 AM

Change 747122 had a related patch set uploaded (by Nikerabbit; author: Nikerabbit):

[mediawiki/extensions/Translate@master] TranslatorActivity: Implement caching for inactive languages

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

Change 747122 merged by jenkins-bot:

[mediawiki/extensions/Translate@master] TranslatorActivity: Implement caching for inactive languages

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