Apache Allura™ / Tickets / #6709 Performance issues in ACL logic for blocking users

#6709 Performance issues in ACL logic for blocking users

Milestone: v1.0.1

Status: closed

Owner: Tim Van Steenburgh

Labels: performance (126) sf-2 (994)

Component: General

Reviewer: Dave Brondsema

Updated: 2015-08-20

Created: 2013-09-24

Creator: Dave Brondsema

Private: No

Suspect changes from [#6392] like https://sourceforge.net/p/allura/pastebin/5241fe8d1be1ce40366e7b29 are at fault.

Seeing a lot of queries like:

Tue Sep 24 20:52:23.721 [conn5127276] query pyforge.project_role query: { project_id: ObjectId('50c218025fcbc909b58b271b'), name: "*anonymous" } ntoreturn:0 ntoskip:0 nscanned:1591 keyUpdates:0 numYields: 10 locks(micros) r:1780438 nreturned:1 reslen:108 1094ms

Which is an unindexed query and perhaps not even a necessary query, when it is *anonymous

Tim Van Steenburgh - 2013-09-25

status: open --> in-progress

assigned_to: Tim Van Steenburgh
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Tim Van Steenburgh - 2013-09-25

status: in-progress --> code-review
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Tim Van Steenburgh - 2013-09-25

allura:tv/6709

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dave Brondsema - 2013-09-25

QA: Dave Brondsema
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dave Brondsema - 2013-09-25

status: code-review --> closed

Size: --> 2
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Apache Allura™

Forge software for hosting software projects

Milestone

Searches

Help

#6709 Performance issues in ACL logic for blocking users

Related

Discussion