Jan 18, 2007 AnyDAC is faster than most data access components at SQL command execution and offers great features, like command array execution.
AnyDAC provides command array execution feature. It dramatically increases performance if you need to execute one SQL command many times with different parameter values. In general, the idea of command array execution is to submit a single RDBMS command with an array of parameters. All parameter values are arrays of the same size and we can ask the RDBMS to execute a command once for each array item. This technique reduces the amount of communication between RDBMS and client enormously and speeds up execution. The following picture shows this feature: 
|
