Slow performance in query when including 3 summary information filters

Constituent query takes over 3 hours to complete when including 3 summary information filters.  If the query is modified to only include 2 summary information filters, the query runs within minutes.

The individual criteria filters that make up the problem query run fast on their own, but the combination of all of these different criteria filters is causing the slowness.  The current architecture of RE7 query builds all of the query critteria into the same SQL statement (in the backend), which multiplies the amount of rows that need to be looked at and causes SQL server to bog down.

1. Split the queries up, and bring them through Queue to refresh them
2. Wait for the query to complete


 7.91.5056, patch 18 ; 7.91.5056, patch 12

Was this article helpful?