|
If you were logged in you would be able to see more operations.
|
|
|
|
Issue Links:
|
Duplicate
|
|
|
|
This issue is duplicated by:
|
|
CORE-3821
There is no batch update in Firebird 2.5.1/Jaybird 2.2
|
|
|
|
|
Relate
|
|
This issue relate to:
|
|
CORE-5951
Add support of batch insert and update operations.
|
|
|
|
|
|
Replace
|
|
|
|
This issue is replaced by:
|
|
|
CORE-5951
Add support of batch insert and update operations.
|
|
|
|
|
|
|
|
SFID: 1164037#
Submitted By: rdebay
JDBC has a feature called batched statements. To put it simply, an SQL statement is prepared, sets of parameters are added to the batch, and then the batch is executed.
Currently, Jaybird takes the list of parameter sets, and executes each one with isc_dsql_exec2. Other databases have APIs that allow the entire list of parameter sets to be sent across, and the server then loops through them, executing each one in turn against the prepared SQL statement.
This greatly reduces wire traffic, with equally large gains in performance.
|
|
Description
|
SFID: 1164037#
Submitted By: rdebay
JDBC has a feature called batched statements. To put it simply, an SQL statement is prepared, sets of parameters are added to the batch, and then the batch is executed.
Currently, Jaybird takes the list of parameter sets, and executes each one with isc_dsql_exec2. Other databases have APIs that allow the entire list of parameter sets to be sent across, and the server then loops through them, executing each one in turn against the prepared SQL statement.
This greatly reduces wire traffic, with equally large gains in performance. |
Show » |
|
New Feature
- detailed information about error happened when processing particular message in batch,
- ability to use BLOBs in batches (efficient in a case of relatively small blobs).