Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT OLEDB connection is very slow

New Member
Posts: 2
Country: USA

ACT OLEDB connection is very slow

ACT has two type of connection
   a) OLEDB direct
   b) ACT OLEDB

When we are connecting as OLEDB direct, it is working fine, but we are able to use only from one Window's user.
When we use ACT ALEDB connection, we are able to connect from any window's user, but it is very slow.

Looking input :

Can we change MSSSQL configuration to allow window's user to connect by using OLEDB direct?

OR there is any way to improve ACT OLEDB connection performance.

Employee
Posts: 1,163
Country: USA

Re: ACT OLEDB connection is very slow

An OLEDB connection string should be using an Act! username and login information as this will enforce field security and any other business rules associated with that login. 

 

If that's already the case, do queries against any table have the same performance issues or is it related to a particular query?

Matthew Wood
Act! SDK Support
Community Moderator
New Member
Posts: 2
Country: USA

Re: ACT OLEDB connection is very slow

Yes, we were using ACT login.

 

And we observed slow performance for msot of the table.

 

Any idea why it is slow with ACT-OLEDB connection?

Can we do some setting to improve that?