ubuntu-translations-coordinators team mailing list archive

[William Grant <me@xxxxxxxxxxxxxxxxxx>]

I experimented with rewriting the query to use trigram indices for
substring matching. The temp_* indices in
https://pastebin.canonical.com/74853/ are new,
https://pastebin.canonical.com/74853/ is a code diff to use them, and
https://pastebin.canonical.com/74852/ is an example of the final query.
It works fine (hundreds of milliseconds) for obscure strings like
'pcman', but strings with common trigrams like 'program' end up spending
a couple of seconds in the GIN trigram indices. I suspect that proper
FTI would be substantially faster.

-- 
You received this bug notification because you are a member of Ubuntu
Translations Coordinators, which is subscribed to Ubuntu Translations.
Matching subscriptions: Ubuntu Translations bug mail
https://bugs.launchpad.net/bugs/869824

Title:
  Doing a search in the ddtp-ubuntu project's translations templates
  times out

Status in Launchpad itself:
  Triaged
Status in Ubuntu Translations:
  Triaged

Bug description:
  Trying to search for a string to translate in the ddtp-ubuntu seems to
  always cause a timeout:

  https://translations.launchpad.net/ddtp-ubuntu/oneiric/+pots/ddtp-
  ubuntu-universe/ca/+translate?batch=10&show=all&search=modeller

  Here's one of the OOPSes I got: OOPS-2106CF25

To manage notifications about this bug go to:
https://bugs.launchpad.net/launchpad/+bug/869824/+subscriptions