what is the best way, in terms of performance, to do
multiple insert/update statements, a PreparedStatement or
Batch Updates?
Answer Posted / ravi
It depends on the context. If you have many records that
need to be updated and you are not bothered about having
interactive session, I would choose batch. But that raises
the question, where do you store all the transactions that
need to be persisted/updated until the batch runs. Do you
want to store to a temporaray storage before updated. It
depends on the design on the system.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Discuss the procedure of retrieving warnings?
Describe the steps needed to execute a sql query using jdbc.
What is drivermanager in jdbc?
What are the common jdbc exceptions?
What are the three parts of a jdbc url?
Under what circumstances, that all four drivers are used?
How we can you use preparedstatement.
Is java a database?
what happen if we set JDBC string to NULL?
Explain the difference between resultset and rowset in jdbc
How to make updates to updatable result sets in jdbc?
Is possible to open a connection to a database with exclusive mode with JDBC?
What is ojdbc14 jar?
What is jdbc in dbms?
What are the considerations for deciding on transaction boundaries?