I have rather simple stored procedure, being called many, many times from C# application using XSD.
I think if I called it once using array it would be quickly. The database and code are different server so it is taking very long to run code
INSERT INTO [dbo].[myTable] ([a], b, [c]) VALUES (@a, @b, @b);
so include of calling procedure say 5 times like this
I'd like to call with array ( "1,2,3,4,5", "2,2,2,2,2", "10,20,30,40,50")
I think this would be quicker as only have to authorise once etc.
Please advise, thank-you