Using stored procedures
Yes you will get a performance boost if you do this entirely on the server as the IO will be contained entirely inside the database server.  However, at the same time you will introduce a performance hit on the server potentially.  

It's a trade-off but I'd say it's worth it if you have spare capacity.