Query based on last gift with soft credit to recipients is very slow

When running a Constituent query based on last gift date between X and Y with soft credit to recipients it is very slow to complete.  If changing to soft credit to donor, it completes quickly.  

We have evaluated this issue as a bug and we have determined it will not be addressed in the program in its current state.  In this case, we believe the risks and challenges outweigh the potential benefit of resolving this issue. We strive to select the most impactful changes and issues to address with each release to accelerate the rate at which we deliver new features while sustaining the highest level of quality for our customers.

 

We recommend adding any program suggestions to our Ideas Community page. Our developers check here first when building program enhancements to see what our users are most interested in seeing implemented.

Steps to Duplicate

1. login to The Raiser's Edge
2. go to query>New Constituent Query>Dynamic
3. Add criteria
Last Gift Date between 4/1/2016 and 10/31/2016
4. Go to Tools>Query Options>Gift Processing.  Set Soft Credit to recipients, use distribution in Grid
5. Click Run Now and it takes 9 minutes to process 2726 records
6. Go to Tools>Query Options>Gift Processing.  Set Soft Credit to Donor
7. Click Run now and it completes in less than 10 seconds

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.