ubuntu-l10n-de-community team mailing list archive

[William Grant <me@xxxxxxxxxxxxxxxxxx>]

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
RAM.

 - 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).
https://bugs.launchpad.net/bugs/736005

Title:
  POFile:+translate timeouts

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

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)
         OOPS-1900K842

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