The _all_members code will help I suspect, if refactored to be able to select on status;
Likewise, moving to set based operations on the candidates will massively reduce DB calls.
The _all_members code will help I suspect, if refactored to be able to
select on status;
Likewise, moving to set based operations on the candidates will
massively reduce DB calls.