Closed Bug 1436985 Opened 2 years ago Closed 8 months ago
Speed up locale queries
44 bytes, text/x-github-pull-request
|Details | Review|
looking at new relic, the most expensive queries overall are starting from the locale table (for sync) and are ordering name, code. It seems that the ordering is what is making this so expensive, and there is a related (Bug 1394194) to make ordering code only. This may/not make the query fast as i have other indeces in play and i havent yet tested ordering only by code with these queries...
...but certainly by either removing the ordering altogether, or making it code only with some indeces will take a large percentage of these queries, and strain from the db.
on further testing having no ordering at all is much faster, indeces dont seem to count for much here. As ordering can be done in python relatively easily (with the caveat that python unicode sort !== db unicode sort) it seems like a good idea to just do the sort in python
Priority: -- → P3
Summary: Optimize locale queries → Speed up locale queries
WIP PR (closed): https://github.com/mozilla/pontoon/pull/844
Assignee: nobody → codewithaniruddha
Status: NEW → ASSIGNED
Status: ASSIGNED → RESOLVED
Closed: 8 months ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.