Hi, All,
Right now, we are using VMWare Host and Windows 2003 Guest with Citrix Destop to execute Excel 2003 & Jet Report 2009.
According to the Windwos 2003 life cycle ending, we upgraded to windows 2012, and using Excel 2010 & Jet Report 2009.
After testing the new environment, there exists a lot of performance issue, the reports take more time to execute, even more than the old windows 2003 environment.
We try to use Jet Report 2015, the performance is a little better. After testing, about 65% of Reports are slower than the Windows 2003 box.
I contact with a VMWare Consultant. He had checked our environment. He told us that, Jet Report has just execute with one Core, even we assign all Cores to the VM, the performance is still worse.
My question is:
1. Is there any 64bit version of Jet Report? By using 64 bits version, could we get more performance enhance?
2. Is there any version of Jet Report consider the Citrix and VMWare environment and optimize for these VM environment?
3. Are there any guideline for Jet Report performance tuning?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello -
First, I would recommend using the latest release of Jet Professional (2017 R2).
To answer your questions directly:
1) Is there any 64bit version of Jet Report? By using 64 bits version, could we get more performance enhance?
Yes. The version of Jet must match the version of Excel. Thus, if your installation of Office is 64-bit, Jet Professional will install as 64-bit application.
Using 64-bit can have a positive impact on report performance if you are *not* using 32-bit Dynamics NAV. If you are using 32-bit NAV, for performance reasons, we strongly recommend the use of 32-bit Office.
2) Is there any version of Jet Report consider the Citrix and VMWare environment and optimize for these VM environment?
There are guidelines for using Jet Professional in a Citrix environment. You can found those in the online knowledgebase: https://jetsupport.jetreports.com/hc/en-us/articles/219402187
3) Here is an article that discusses certain "Best Practices" with using Jet Professional: https://jetsupport.jetreports.com/hc/en-us/articles/218954558 -
Jet Reports Historic Posts Hi, HP,
Thanks for your post so quickly.
It seem that the bottleneck was the NAV 2009, because NAV 2009 is based on old system architecture.
Anyway, our NAV 2009 could not been upgraded, because of huge customized function re-write effort and cost.
What if we use the physical server and Citrix, not VMWare? -
Jet Reports Historic Posts Hi -
While I do not have an empirical evidence to cite, I would suspect that using Citrix (following the guidelines listed in the Jet KB) to access a physical server would provide better performance than VMWare.
Also, because your installation of NAV is 32-bit, you would get your best results if Excel (and, thus, Jet) is also 32-bit.
Please sign in to leave a comment.