I wish to use single database connection from multiple threads to see (in order to execute only choose claims) in MS SQL Server in concurrently. Can you really execute each one of these choose claims in concurrently from different threads.
I m using MS SQL Server from C++ in Linux atmosphere. I have to create Database connection pools for reading through and writing individually. So i wish to know it is possible to chance of discussing a same link between threads to see only.
The choose claims may return multiple rows (several row or result set). Will this be considered a problem?
Yes you will see an issue. Just one command could be performed at any given time. But you will be fine using multiple connections, connection pooling is effective for SQL server.
Avoid using exactly the same connection across threads. Just one command could be performed per connection. Produce a connection for every thread. I'd suggest creating a assistant class to create this simpler for you personally.
I wish to use single database connection from multiple threads to see (in order to execute only choose claims) in MS SQL Server in concurrently
You can start reading through the documentation and never start getting funny ideas that whas you would like matters here.
Yes, it can be done (MARS may be the subject- see clearly up) only one connection can alwayso nly have one transaction context therefore it isa good method of ahvem ultiple chooses in a single transaction (place, handful of upserts etc.) but bad like a generic method for progrmaming database connections.
Stick to the quality recipes which mean iopen a conenction when it's needed, close it when done and do not be afraid to operate mtultiple connections.