Issue Details (XML | Word | Printable)

Key: CORE-820
Type: New Feature New Feature
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: rdebay
Votes: 3
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

isc_dsql_exec* should allow list of parameter sets

Created: 15/Mar/05 12:00 AM   Updated: 25/Oct/18 12:38 PM
Component/s: API / Client Library
Affects Version/s: None
Fix Version/s: None

Issue Links:
Duplicate
 
Relate
 
Replace
 

SF_ID: 1164037


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.