Interested to Buy Any Domain ? << Click Here >> for more details...
what is the best way, in terms of performance, to do
multiple insert/update statements, a PreparedStatement or
Batch Updates?
- 2 Answers
- 4763 Views
- I also Faced
- E-Mail Answers
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
What is the different between ResultSet and RowSet?
What are the advantages of database connection pooling?
What is benefit of using preparedstatement in java?
How can we retrieve data from the resultset?
What are dml and ddl?
What is dburl?
What is xe in oracle jdbc url?
How do I disallow NULL values in a table?
Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?
Explain the locking system in jdbc & its types?
What does the jdbc resultsetmetadata interface?
What is jdbc driver in java?
What is the return type of execute, executequery and executeupdate?
What are database warnings in jdbc and how can we handle database warnings in jdbc?
What is the benefit of having jdbcrowset implementation?
