How can I pinpoint where performance issues are occurring, i.e. SQL generation vs query vs calculation vs report generation vs download time? I haven't set up loggin in the database -- does it track those items?
We're having a problem with remote users (laptop, VPN, etc) having much slower performance than network users -- 10 minutes on VPN vs 2 minutes on network. In theory, since all the processing takes place on the server, the disparity should not be that great. Download time should be the only difference, and when I save a report as a PDF, our default format, it is only 167KB.
We're having a problem with remote users (laptop, VPN, etc) having much slower performance than network users -- 10 minutes on VPN vs 2 minutes on network. In theory, since all the processing takes place on the server, the disparity should not be that great. Download time should be the only difference, and when I save a report as a PDF, our default format, it is only 167KB.