Passing multiple tables from stored procedure performance

378 Views Asked by At

If we pull multiple tables from stored procedure instead of procedure per table, how it will affect Sql Server's performance?

1

There are 1 best solutions below

3
On BEST ANSWER

In terms of the database engine itself and the load on it, it makes little difference.

In terms of network IO, it is normally better to do one big query than several small ones, as each connection takes some time to setup.

In general - pull in all the data you need in one batch instead of several if performance of the database and application are important.