04-10-2012 02:18 PM
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?
04-10-2012 09:21 PM
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.