Why is my DAT Query or DAT Filter slow?
Posted April 21, 2019
DAT Query performance depends on the complexity of the query and the volume of data being processed. Some tables perform advanced calculations, which can add processing time even when a query appears simple. The more tables, conditions, and filters included, the slower a query may run.
To improve DAT Query or DAT Filter speed:
- Use the “=” or “<>” DAT Operators instead of Contains, Not Contains, Starts With, or Ends With.
- Avoid relinking to the same table multiple times.
Related articles
More from the Knowledge Base
Still have questions?
Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.
New to PCR Educator?
If you landed here from a search and want to see what PCR Educator can do, the demo is the fastest way in. Thirty minutes, no commitment.