Devart Forums

Hi,

I would like to know if there are any limits for the SDAC?
We are on the way to replace BDE in our programs
and would like to know more about:

1. Max.Number of TMSQueries per TMSConnection,

2. Ability to execute TMSQueries in parallel inside one TMSConnection,

3. How many TMSConnections can be created in DCOM Server type of Application, per thread, per Application, per Computer

4. Can TMSConnection be shared between threads? Like having a global
connection...

4. Any limits on BLOB data transfer

I believe there is no limits to 64K for SQL statement in this package.

Thank you.

> 1. Max.Number of TMSQueries per TMSConnection,

We haven't known about this restriction.

> 2. Ability to execute TMSQueries in parallel inside one TMSConnection,

This behaviour is impossible for MS SQL Server.

> 3. How many TMSConnections can be created in DCOM Server
> type of Application, per thread, per Application, per Computer

Hard to say. Nobody has informed us about similar restrictions till now.

> 4. Can TMSConnection be shared between threads?

Only if these threads are executed sequentially.

> Like having a global connection...

Pat attention to TMSConnection.ConnectionPooling, probably this property will be
helpful for you.

> 4. Any limits on BLOB data transfer
> I believe there is no limits to 64K for SQL statement in this package.

We haven't known about such limits.

We advise you to download trial version and check features you are interested in yourself.