Hi all,

I have a java database application which mainly deals with database operations.

Im concerned about the performance, as I have many update statements. As there are many records, each row has to be updated with a calculated value.


So can anybody help me out to suggest for efficient way of doing this.

Thanks.

How are you doing all that currently ?

Better to use stored objects than executing raw SQL.

Im doing batch update, but stil i have performance issues.

Is the data being used by some other process while you run batch update ?

threads are created for a every set of records.

Make sure that your query is using indexes. What does "EXPLAIN <your-update-query>" tell you?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.