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
- 4647 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 metadata in programming?
What are different parts of a url?
Does jdbc use ssl?
Explain the difference between inner and outer join ?
What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?
What is a lock in jdbc?
Can we have foreign key reference to a non primary key column ?
What is difference between statement and preparedstatement in jdbc?
What is statement and resultset in jdbc?
What is the use of jdbc?
Explain the main method?
What is a connection string used for?
What is url in jdbc connection?
Which is better jpa or jdbc?
What is a jdbc driver and how many jdbc drivers are available?
