SQL Server query result transfer time over VPN (WAN)
In your VPN properties, click options, PPP Settings.
Do you have "enable software compression" ticked?
SQL data compresses quite nicely, and if the remote site is heavily used bandwidth wise, it may simply be struggling to send you the data.