File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Update in For loop. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Update in For loop." Watch "Update in For loop." New topic

Update in For loop.

es kranthi
Ranch Hand

Joined: Dec 27, 2010
Posts: 32
I just wanted to know whether writing update SQL query inside a for loop will effect the performance of the Database or not.Since everytime we iterate and update the record.Hence we are updating the Database this may increase the load on the Database hence the performance.


Sample code please donot conside syntax

Thanks and Regards.
Sudheer Bhat
Ranch Hand

Joined: Feb 22, 2011
Posts: 75
Check out PreparedStatement and executeBatch of Statement
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Well, yes, if you update a table then that is going to cause the database to do some work. And obviously that means the load on the database is increased, because now it has to do some work that it wasn't doing before. But that's trivially obvious and clearly not what you were looking for.

Unfortunately it's hard to tell what you are looking for instead. Based on your post there isn't much more that can be said.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33098

You should use batching. The database can be more efficient if you give it more records at the same time because it makes less trips to the database, less commit statements, etc.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Arun Chidam
Ranch Hand

Joined: May 08, 2006
Posts: 79
if you get the employee id's list from the database table, then you can also look into using SP instead of update inline SQL

SCJP 1.4, SCWCD 1.4
I agree. Here's the link:
subject: Update in For loop.
It's not a secret anymore!