Connection Pooling

[tdowning@solidconcepts.com]

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?

[rchavez]

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.