Batch Operations - ValueCount

[chkaufmann]

Hi,

I played arround with the feature for batch operations. The speed improvement is really impressive. My question is, what should I use for "ValueCount"?
- Is there a limitation given by UniDAC?
- What are the limitations on different databases (Firebird, SQL Server, Oracle, PostgreSQL)?

cu Christian

[azyk]

In Batch Operations each dataset parameter contains a values array and the array size is defined by the ValueCount value.

- UniDAC does not contain any restrictions in the ValueCount value.

- regardless of the restrictions placed by various DBMSs on bulk operations, UniDAC for each DBMS executes these operations in an optimal way (including Firebird, SQL Server, Oracle, PostgreSQL). To maximize the efficiency for each individual case, you can change the Batch Operations parameters by yourself.