Hi All,
I'm working on an installation of Navision and Jet reports which is going well.
However the users have noticed recently that running Jet Reports has slowed dramatically and some reports are taking close to 12 mins where they used to take 2.
Is there a configuration that I can improve?
Also switching between Design and Report causes the report to run and refresh, whilst we are building new reports is there any way of turning this off as it's become fairly slow for people to build?
Thanks for your help in advance.
Nashco
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Nashco.
You mentioned both that you are working on an installation and that some reports are taking longer than they used to.
The first question to examine is what has changed between the time when the reports were faster and now?
That may give some indication as to what has impacted the performance.
Regarding your second question:
Any time that the report is run (using either Report or Refresh) data will be retrieved. Obviously, this takes a certain amount of time to do. If a great deal of data is being retrieved, it would probably be best to limit the number of times that the report is run while the user is engaged in designing the report. Using Report should be somewhat faster than using Refresh (as Report will used whatever cached data it can, while Refresh will retrieve all data from the database).
There are some "Best Practices" which can help with report speed. You can find a discussion of these in the Jet Knowledgebase –> https://jetsupport.jetreports.com/hc/en-us/articles/218954558
Please sign in to leave a comment.