PERFORMANCE: Marketing Effort Query takes longer to run in the latest version when compared to previous versions

Marketing Effort Query with Segments takes hours to run in 4.0 environment, when in the previous version of 2.91, the same query run took minutes to complete.
We’re currently evaluating this issue for a fix in a future release.

Steps to Duplicate

  1. Go to Analysis > Information Library
  2. Search for and open a Marketing Effort Query
  3. Under Results section, click "Click here to process the query and view the results"
  4. Note: Query runs for hours and has been manually terminated with each run without completing due to length of runtime; however, same query completes in minutes in previous version 2.91.

Environment

 Blackbaud CRM
 4.0

Was this article helpful?