Query multiple SQL Server tables in parallel

Question

I would like to know if there is way that I can run multiple SELECT queries or stored procedures in parallel? For a long time I was using one stored procedure which looks like below:

SELECT 1.......

SELECT 2 .......

SELECT 3 .......

Then I got DataSet with multiple DataTables.

Now I would like to run each SELECT statements parallel. I am not sure if I can do this using the same SqlConnection or if I have to use a separate connection for each query?

Do I have to use threads?

Does each select statement return the same columns or different columns? — Bernd Linde
– Bernd Linde, Commented Oct 17, 2014 at 8:37
Different. This SELECT statements can be stored procedures too. — ironcurtain
– ironcurtain, Commented Oct 17, 2014 at 8:48
@kumarch How this affect performance? What will be the best way to query multiple tables/view eg. for drop down lists in page? Will creating multiple connections improve the performance? — ironcurtain
– ironcurtain, Commented Oct 17, 2014 at 10:50

Manoj Pandey · Accepted Answer · 2014-10-21 13:44:17Z

1

SQL Server will run all the 3 SELECTs in same session and in sequence as per you've done above.

If you want to execute all 3 SELECTs in parallel then you will have to invoke 3 threads (3 SPIDs, by creating separate connections) and execute by any script, like C# or VBA. But still its not guaranteed if they will run exactly parallel.

answered Oct 21, 2014 at 13:44

Manoj Pandey

1,41714 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query multiple SQL Server tables in parallel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related