Does Analysis Services provide connection pooling
0
votes
1
answer
74
views
We know that when creating a SQL connection, for example:
-cs
using (SqlConnection sqlConn = new SqlConnection(conString));
we are actually not always creating a new connection to the server, but rather we are taking an already open connection from the connection pool .
---
However, when we open a connection to the Analysis Services, do we also use some kind of connection pooling?
-cs
using (AdomdConnection adomdConn = new AdomdConnection(conString));
Does this always lead to a new connection or does it take one from the pool if possible?
I am not able to infer this from the official documentation , but I have found mostly older unofficial articles that clearly state there is no connection pooling for AdomdConnection :
- SQL Server 2005 Analysis Services’s ADOMD.NET Connection Pooling, or Lack Thereof
- ADOMD.NET Connection Pooling
Asked by PajLe
(133 rep)
Apr 25, 2024, 08:36 PM
Last activity: Dec 31, 2024, 04:30 PM
Last activity: Dec 31, 2024, 04:30 PM