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
- 4661 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
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
What does the jdbc databasemetadata interface?
What is jdbc odbc connection?
What is metadata in programming?
What is resultsetmetadata?
What is CLOB and BLOB datatypes in JDBC?
What is the meaning of “dirty read” in the database?
Which Java and java.sql data types map to my specific database types?
What do you mean by two phase commits?
What is com mysql jdbc driver?
What is a jdbc connection pool?
What is difference between odbc and jdbc?
What is the full form of jdbc and what is its purpose?
How do I insert an image file (or other raw data) into a database?
What are temp tables ?
