Solved
in a RD we have 5 filters but its fetching really slow how to fix this?
We have a RD fetching millions of records based on 5 filters specified in it but its working very slow?How to resolve this
***Edited by Moderator Marissa to change type from General to Product, added Product details and Capability tags***
To see attachments, please log in.
Accepted Solution
Posted: 5 months ago
Updated: 5 months ago
Updated: 1 Jun 2024 5:08 EDT
Maantic Inc
Maantic Inc
IN
Use as much equals condition as possible, check use null if empty checkbox, do not read from BLOBs, generate expense plan by taking the SQL that is being generated from the report and analyzing that to see where its taking time.
