Subject | Multiple prepared statements in Jaybird/Firebird |
---|---|
Author | Bill Oliver |
Post date | 2005-05-11T19:16:07Z |
I got this question from a user - do you have any suggestions?
For performance reasons we often bunch up a set of DML statements in
one call to the server. In DB2 we wrap the statements in BEGIN
ATOMIC ... END, in Oracle we use BEGIN ... END, in Postgres and MSSQL
the jdbc driver simply
supports it without changes (i.e. PrepareStatement("stmt1; stmt2; ...
stmtn;"))
Action: How is this done efficiently in Firebird?
Thanks!
Bill Oliver
For performance reasons we often bunch up a set of DML statements in
one call to the server. In DB2 we wrap the statements in BEGIN
ATOMIC ... END, in Oracle we use BEGIN ... END, in Postgres and MSSQL
the jdbc driver simply
supports it without changes (i.e. PrepareStatement("stmt1; stmt2; ...
stmtn;"))
Action: How is this done efficiently in Firebird?
Thanks!
Bill Oliver