Uploaded image for project: 'Zanata'
  1. ZNTA-2191

Need HAccount index to find enabled users efficiently

    Details

    • Tested Version/s:
      None
    • Sprint:
      17.18

      Description

      The modified queries in PR 485 are too expensive (probably full table scan) because there is no suitable index on HAccount.

      We should consider reverting or reducing the rate limiter increases from https://github.com/zanata/zanata-platform/pull/490, since those limits and 429 errors helped to expose the problem with the index.

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                aeng Alex Eng
                Reporter:
                sflanigan Sean Flanigan
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: