Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Nickel Elite Contributor
Posts: 107
Registered: ‎03-09-2011

Connection Pooling

Does the SalesLogix SlxOleDbProvider support ConnectionPooling?

 

Max Pool Size

Min Pool Size attributes?

 

If so, where is it configured?

Would this be in extended properties through the connection manager or something else?

 

Bronze Super Contributor
Posts: 129
Registered: ‎06-09-2009

Re: Connection Pooling

I don't know the answer to your question, but want to throw some details out there:

 

  The OLEDB Provider does perform a set of Tasks to prepare queries, but it then passes them along to an Actual SQL Connection.

 

  It is highly likely that the SQL Connections are pooled (since they would be using a single login - sysdba).

 

  If you have multiple SLX Users, keep in mind that you will have different Connection Strings, so even if you were pooling the connections, they won't be reused across users.

 

 

  Again, I don't know the answer to your question, just adding some commentary. It would be nice to get some additional details.

 

  

Raul A. Chavez
http://raul.chavez.com
http://www.crmbi.com