Member Avatar for divyakprabh

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.

  • 3 Contributors
  • 5 Replies
  • 65 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by smantscheff

Recommended Answers

All 5 Replies

Member Avatar for debasisdas

How are you doing all that currently ?

Better to use stored objects than executing raw SQL.

Edited by debasisdas because: n/a
Member Avatar for divyakprabh

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

Member Avatar for debasisdas

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

Edited by debasisdas because: n/a
Member Avatar for divyakprabh

threads are created for a every set of records.

Member Avatar for smantscheff

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.