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 Translations Coordinators, which is subscribed to Ubuntu Translations. Matching subscriptions: Ubuntu Translations bug mail 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 _______________________________________________ Mailing list: https://launchpad.net/~ubuntu-translations-coordinators Post to : ubuntu-translations-coordinators@lists.launchpad.net Unsubscribe : https://launchpad.net/~ubuntu-translations-coordinators More help : https://help.launchpad.net/ListHelp