web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Reports slow performance?
Microsoft Dynamics NAV (Archived)

Reports slow performance?

(0) ShareShare
ReportReport
Posted on by Community Member

there is a case where Navision 2009r2 with LS retail 6.4 is suddenly having a slow performance reporting issue! Reports based on TSE table (size=27GB). Its SQL DB (150GB) , simple recovery mode,where maintenance is frequently running along with update statistics. 32GB RAM Server, Raid 1+0 (6x300GB). Any suggestions?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at
    RE: Reports slow performance?

    hi,

    slow performance in reports is normally caused by:

    * a large amount of data

    * data, which is loaded many times instead of once

    * (large) images, e.g. logo

    * c/al code in the report or in used codeunit, which is run very often although not necessary

    * insufficient memory

    * slow hardware

    * slow database (connection)

  • Community Member Profile Picture
    Community Member on at
    RE: Reports slow performance?

    Using SQL query is fast while running the report in Navision slow.

  • Suggested answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: Reports slow performance?

    Hi,

    Generally, Large report data cause this issue since it consumes the memory and buffers. For an example : Inventory valuation report.

    Just check the your same report with some small period or set of data and check the time.

    If this is the issue then it needs to optimize the report like using the temp table.

    Regards,

    Saurabh Shah

  • Community Member Profile Picture
    Community Member on at
    RE: Reports slow performance?

    Hi,

    We have noted the issue with reports reading from trans sales entry (Ls retail) while GL reports like inventory valuation is going on normal. The reports were fast before but now it very slow. (before up to 15mins, now exceeds 45min)

  • keoma Profile Picture
    keoma 32,729 on at
    RE: Reports slow performance?

    hi,

    what has changed on the report, on the table?
    how many pages does the resulting report have?
    how many data rows, how many columns?
    do you print images? how much, what's their size (in MB)?
    please embed a screenshot of the report in your answer.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans