#6712 project_role collection growing unnecessarily

v1.0.1
closed
General
2015-08-20
2013-09-26
No

New user ban functionality calls user.project_role(project=project) which upserts a project_role record. This is causing an unnecessary increase in project_role records. The ban logic shouldn't create new records. And potentially other uses of project_role() shouldn't be creating new records either, or at least be explicit if they need a record created.

This is causing performance issues because the number of roles for the p.--init-- project is growing, and queries from Credentials.load_project_roles are fetching all of them which is getting slow.

Discussion

  • Cory Johns

    Cory Johns - 2013-09-26
    • status: in-progress --> code-review
     
  • Cory Johns

    Cory Johns - 2013-09-26

    allura:cj/6712

     
  • Cory Johns

    Cory Johns - 2013-09-26
    • Size: --> 1
     
  • Dave Brondsema

    Dave Brondsema - 2013-09-26
    • status: code-review --> closed
    • QA: Dave Brondsema
     

Log in to post a comment.