Patch #16925
Improve performance of Principal.member_of scope
| Status: | Closed | Start date: | ||
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Jean-Baptiste Barth | % Done: | 0% | |
| Category: | Database | |||
| Target version: | 2.6.0 |
Associated revisions
Improve performance of Principal.member_of scope
The 'join' turns to be slow for large numbers of members (>20k). Using a
sub-query like in Principal.not_member_of is more efficient and performance
is the same for smaller values.
History
#1
Updated by Jean-Baptiste Barth about 7 years ago
- Status changed from Resolved to Closed
Fwiw I have this in a plugin for 4 months and it works great. I close the issue, the commit will be integrated when JPL creates the 2.6-stable branch I think.