Skip to main content
ETO Results | Query Summary Cell

BO 4.3 Platform

Updated over a week ago

A single report can have multiple queries; splitting up a query up can often speed up a report. If a report contains multiple queries and is running slow, you can add a "Query status" report to see which ones are taking a long time to refresh:

  1. Click on the Plus Icon next to the main panel on the right side of the screen to create a new report.

  2. Click on the abc icon in the Insert Section.

  3. Select Query Summary from the drop down options.

  4. Click within the new report tab to place the Query Summary cell.

  5. This will show a list of each query, how many rows of data are being retrieved, and how long (in seconds) the query is taking to run.

If a query is returning a lot of records, it may need to be narrowed. Returning a lot of records, however, does not always mean the report will run slowly. If a query is taking a long time to run (60+ seconds) but still not retrieving much data (under 5,000 records), the data types may need to be split up into separate queries to improve the efficiency of the report.

Mixing any two to three of the following types of data in a single query can slow it down:

  • Demographics

  • TouchPoints

  • Assessments

  • Points Of Service

  • Efforts

  • Caseload

  • Program Enrollments

Did this answer your question?