Group list loader performance, calls GroupSave for every group

XMLWordPrintable

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Minor
    • None
    • Affects Version/s: None
    • Component/s: daemon
    • None

      Working with a customer on why sql list loaders are slow. For every group in scope, it's calling GroupSave even if nothing has changed in the group. The slow part of that operation seems to be privilege checks. The operation takes on average 600+ ms in postgres, which is far slower than anything else.

      Their particular installation does have EveryEntity with read, which is what the slow query is looking for. But even in a default installation, it's still making the call.

      Maybe don't call GroupSave if nothing is changing in the group? Or maybe the GroupSave can be refactored to not worry about privileges when saving?

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Chad Redman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: