[allura:tickets] #6712 project_role collection growing unnecessarily

[Dave Brondsema <br...@users.sf.net>]

---

** [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 sourceforge.net because allura-dev@incubator.apache.org is subscribed to https://sourceforge.net/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.