>The processing would be done on the server instead of on the client. Not sure it will help you that much as it looks like the Insert statement is pretty basic, but it is something to try.

Ever waited on the subway? I believe it's better to balance the performance between the client and the server than to just put everything on the server.

In this case the data originated with the client. Having it flow to the server via a stored procedure or via an insert statement should be equivalent, right? In either case, the processing is done on the server. It either executes the SP or it executes the insert statement.