Issues Moving Dataset to DB

[pturmel]

If you use a competent database backend, you can do essentially unlimited rows per batch with just one ? placeholder per column:

Stored Procedure call overhead-way to batch?

We have a data query application that calls a stored procedure within a script, potentially 90 times for a single execution. There appears to be some overhead associated with the creation and execution of the stored procedure, making the script itself take sometimes 10+ seconds. Without moving away from the stored procedure approach, is there a way to batch these calls to optimize performance? Generically, we pass a couple of values to the stored proceudre, then write the response to a plc…

{ Sorry, Jason, MS SQL Server is not a competent database. }