incubator-allura-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Brondsema" <>
Subject [allura:tickets] #6712 project_role collection growing unnecessarily
Date Thu, 26 Sep 2013 18:54:21 GMT


** [tickets:#6712] project_role collection growing unnecessarily**

**Status:** in-progress
**Labels:** performance 
**Created:** Thu Sep 26, 2013 06:54 PM UTC by Dave Brondsema
**Last Updated:** Thu Sep 26, 2013 06:54 PM UTC
**Owner:** Cory Johns

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.


Sent from because is subscribed to

To unsubscribe from further messages, a project admin can change settings at
 Or, if this is a mailing list, you can unsubscribe from the mailing list.
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message