Patch #16925

Improve performance of Principal.member_of scope

Added by Jean-Baptiste Barth about 4 years ago. Updated almost 4 years ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Jean-Baptiste Barth% Done:

0%

Category:Database
Target version:2.6.0

Description

Using a sub-query is faster, see r13139. Targetting for 2.6.0.

Associated revisions

Revision 13139
Added by Jean-Baptiste Barth about 4 years ago

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 almost 4 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.

Also available in: Atom PDF