what is the best way, in terms of performance, to do
multiple insert/update statements, a PreparedStatement or
Batch Updates?
- 2 Answers
- 4216 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 are the steps to connect to the database in java?
Why do I have to reaccess the database for Array, Blob, and Clob data?
What is transaction processing in jdbc?
How can I get information about foreign keys used in a table?
What is jdbc type?
Is jdbc and orm?
How do I know which jdbc driver to use?
How can I retrieve a String or other object type without creating a new object each time?
Is jdbc a framework?
What is jdbc and jpa?
What are the different types of statements? How we can you use preparedstatement.
Where is jdbc used?
What is jdbc connection class?
What class.forname will do while loading drivers of jdbc?
Where can I find ojdbc14 jar file?
