© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
The Phase-2 schema optimization made a vast difference here, reducing timeouts by almost 90%.
More things we can do here:
* Keep "translations to English" out of POFileTranslator, and remove the check for those from the slow query.
* Upgrade the database server. There's a new optimization we'd be likely to benefit from with the above changes.
* Index on (person, date_last_touched).