← Back to team overview

ubuntu-l10n-de-community team mailing list archive

[Bug 736005] Re: POFile:+translate timeouts


There are two big problems with this page, shown by the first and last
OOPSes in comment #16 respectively:

  - The Launchpad Translations schema is really slow for text searching.
Requests affected only by this problem will usually stop OOPSing after a
few refreshes get the data cached in RAM. Fixing the schema to make this
fast on HDDs is very difficult. But this problem *should* go away in a
couple of weeks when we upgrade to new DB servers with SSDs and more

 - The +translate page needs to preload data it's using, rather than
making several hundred queries once it's worked out which translations
are relevant. This will be mitigated by the new DB servers, but we need
to fix this properly.

You received this bug notification because you are a member of Ubuntu
German Translators (Community-Team), which is subscribed to a duplicate
bug report (1084026).

  POFile:+translate timeouts

Status in Java OpenStreetMap editor:
Status in Launchpad itself:
Status in Ubuntu Translations:

Bug description:

    1 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
     GET: 1 Robots: 0  Local: 1
        1 https://translations.launchpad.net/picapy/trunk/+pots/picapy/de/+translate (POFile:+translate)

To manage notifications about this bug go to: