Language pack performance
Bug #277598 reported by
Jeroen T. Vermeulen
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Launchpad itself |
Fix Released
|
High
|
Jeroen T. Vermeulen | ||
Bug Description
Generating a language pack is dramatically slow at the moment. The process is almost entirely CPU-bound.
The cause is too many objects being fetched individually by id, which in turn is done because memory on the script server used to be the big bottleneck. It's not even the database queries themselves that cost time (not since the db server upgrade); it's Storm composing SQL expressions for the objects' columns.
For now, need to fetch POTMsgSets in bulk to reduce the number of Storm queries. Other suspects are POFile, POTemplate, and Language. Should make the time spent on client-side computation neglible.
| Changed in rosetta: | |
| assignee: | nobody → jtv |
| importance: | Undecided → High |
| milestone: | none → 2.1.10 |
| status: | New → In Progress |
Revision history for this message
| Jeroen T. Vermeulen (jtv) wrote | #1 |
Revision history for this message
| Jeroen T. Vermeulen (jtv) wrote | #2 |
| Changed in rosetta: | |
| status: | In Progress → Fix Committed |
| Changed in rosetta: | |
| status: | Fix Committed → Fix Released |
| visibility: | private → public |
To post a comment you must log in.
POTMsgSet.