Additional
Overview
Features
Get
Discuss
News
Partners
Firebird Associate
 
Array Command Execution PDF Print E-mail
Jan 17, 2007

FreeDAC is faster than most data access components at SQL command execution and offers great features, like command array execution.

 

FreeDAC 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:

 

Array command execution