New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
isc_dsql_exec* should allow list of parameter sets [CORE820] #1206
Comments
Modified by: @pcisarissuetype: New Feature [ 2 ] => Improvement [ 4 ] assignee: Dmitry Yemanov [ dimitr ] SF_ID: 1164037 => |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] => Vlad Horsun [ hvlad ] issuetype: Improvement [ 4 ] => New Feature [ 2 ] SF_ID: 1164037 => |
Modified by: @pcisarWorkflow: jira [ 10844 ] => Firebird [ 15284 ] |
Modified by: Sean Leyne (seanleyne)description: SFID: 1164037# JDBC has a feature called batched statements. To put => SFID: 1164037# 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. |
Commented by: TIP Group, S.A. (Olivier Mascia) (tipgroup) This imply a batch of results too. What if the statement is a SELECT, the results sets are batched too? What about failures (one of the exec instances could trigger errors - depending on the parameter values). How would it be expected to behave? |
Modified by: @dyemanovassignee: Vlad Khorsun [ hvlad ] => Alexander Peshkov [ alexpeshkoff ] Fix Version: 4.0 Alpha 1 [ 10731 ] |
Commented by: Thomas Kragh (realic) Hey for example |
Commented by: @AlexPeshkoff In v4 - definitely not. Primary goal is to support JDBC requirements. May be an ability to execute select statement with parameters sending sets of different parameters' values in a batch will be added in v4 too, but what about execution of different select statements with different sets of output columns that requires changing a way we work with result sets and is out of v4 scope. |
Commented by: @AlexPeshkoff Implemented new Batch interface performing everything needed for JDBC compliance and additionally: |
Modified by: @AlexPeshkoff |
Modified by: @dyemanovFix Version: 4.0 Beta 1 [ 10750 ] => |
Submitted by: rdebay (rdebay)
Is duplicated by CORE3821
Relate to CORE5951
Is replaced by CORE5951
Votes: 3
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.
The text was updated successfully, but these errors were encountered: