1

Performance issues for users working remotely by VPN

Adam Majewski

May 30, 2022 14:24

None

Follow

Hello,

we've noticed a significant performance issues for one of our clients, when user is using Jet Reports, while working remotely, connected to company's VPN. Refreshing the same report, on local PC connected to the vpn, can take more than hour, while it takes only couple of minutes on the remote desktop in client's network. It seems to be an issue with the VPN, but we don't know what exactly can make such a big difference in report generation times. Do you have any tips on what to check or change in order to speed up the report generation on local PCs connected to the VPN? We are using the newest version of Jet Reports (22.1.22137.1).

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  CascadiaDataworks May 31, 2022 17:59

  This is taken from an article on NordVPN.

  "At its core, a VPN's job is to encrypt your connection and send it through a secure VPN server. Because a VPN adds extra steps between you and the Internet, it’s bound to slow down your connection somewhat."

  -------------

  I would also wager that inefficient reports could run slower through a VPN than a local machine, but that you just may not notice the inefficiencies until the VPN comes into play.  The more network calls the report has to make, the more the VPN will slow down the report time.

  You have to keep in mind that the report need to send and receive via the VPN so encryption is happening both directions, essentially doubling the slower speed it needs for each network call.  If you think about a normal report and let's say each network call for a local machine takes .5 seconds to query the database, the VPN may add a 1 second sending and 1 second to receive for the encryption each way.  Now, each call is taking 2.5 seconds, thus making the report run 5x as long.  (Keep in mind, all these numbers are made up, just used to illustrate a point). 

  Unfortunately, there isn't much Jet can do about this as it is outside of the functionality of Jet.  The only thing you can do from a Jet perspective is to ensure reports are built to run efficiently and using all best practices, whenever possible.

  You could also consider running the reports on a RDP without a VPN.

  Edited by CascadiaDataworks May 31, 2022 18:00
• 0
  
  Jeff Mitchell June 02, 2022 07:57

  I just created an account on here to mention as of Tuesday, we are experiencing a similar thing. For the reports we're doing VPN is our only current option, and we've got a critical report that's stalling. It's the first time in the five or six years I've been running on Jet that we've had this report fully stalling. I can try it in peak hours, or now (2 AM), and it's stalling.