Report Performance is very poor

chrispaul

Dear All

I am working on Reports in 2015. There is huge data with around 7 lakhs rows coming out in some reports and the time taken is approx 2 minutes.

There is no code written on the report neither there is any flowfield but still report is taking huge time.

Can you please help me to verify what can be checked / done to improve the report performance.

Regards
Chrispaul

delaghetto

I would start by checking if all neccesary Keys are created in NAV database tables. SQL Indexes can have a huge impact in performance, and a poor design can cause this type of problems.