---
** [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 [email protected] 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.
