Regardless of how you are plugging in - if you pull the data locally first before doing anything with it, you get local SQL performance. If you query it remotely, you're relying on speed over the internet.