Report Performance is very poor

chrispaul
chrispaul Member Posts: 174
edited 2015-06-11 in NAV Three Tier
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

Comments

  • delaghetto
    delaghetto Member Posts: 89
    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.

Categories