- **status**: in-progress --> code-review
--- ** [tickets:#6712] project_role collection growing unnecessarily** **Status:** code-review **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.
