Comment 17 for bug 736005

Revision history for this message
William Grant (wgrant) wrote :

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.