Reply To: Report Builder Report performance

#6769
Israr
Participant

Could be a number of reasons.

One common reason is due to the number of queries it hit on the database. For almost every outer join, it creates a SQL and produce a result table and then finally it joins all the different result tables. Creating each result table doesn’t taking much time, but it’s the number of them which increases the time.

Could look into if the joins in the report can be reduced, or can some of the joins be changed to Inner Join instead or could potentially improve it by introducing / creating some table views.

Download PDF version

This field is for validation purposes and should be left unchanged.