I have a report based on SQL Server stored procedure. It's size just 20K. I store it in 2 places: one copy on my local machine, another one on shared drive on server. I'm using VPN to connect to that server. SQL Server database is located on that server too. When I run this report from VB.NET application and using it's local copy it takes 1 second to be displayed. When I use the copy located on the server then it takes about 20 seconds. What I'm doing wrong? 20 additional kilobytes shouldn't take so long time. Data for report is much bigger and it's delivered very fast (with local copy I use the same data and the report is displayed almost simultaneously).
So what should I do to make it faster?
thank you
Vlad