Reduce the response time when querying the database

342785 pts.
Tags:
Database query
Java
Storage in 2010
I am working on a plain java/J2ee project with Oracle 9 at the backend. The issue comes when I am querying the DB and more than 10000 records are retrieved. I can’t change the business logic much, since the code is developed by some other people and I’m not allowed to do so. Any tuning which we can do to overcome such issue?

Software/Hardware used:
java j2ee

Answer Wiki

Thanks. We'll let you know when a new response is added.

Correctly setup the indexes to improve performance.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITKE
    This question was asked on LinkedIn: http://bit.ly/cmt2ne
    342,785 pointsBadges:
    report
  • Kccrosser
    The most common tuning is to add/configure the right indexes to speed up the retrieval. Can you analyze the query and see where all the cost is occurring? Are there large tables where you see table scans? If so, then a good index (particularly a multi-column index) may speed up the result. How big is the data per returned record? 100 characters (= 1 Megabyte)? 1000 characters (10 Megabytes)? 10,000 characters (100 Megabytes)? You could be running into limits on the actual time to pull that much data down to display it. So - you need to determine: 1. Is the time being spent in the database selecting the records to return? If yes, then indexes can probably help. 2. Is the time being spent downloading the retrieved data to the client for display? If yes, then you need to constrain the size of the returned data. 3. Are your queries using "select *" instead of enumerating just the specific columns of interest? If so, then changing to enumerate the columns may help both of the above.
    3,830 pointsBadges:
    report
  • ITKE
    [...] Reduce the response time when querying the database answered by mrdenny and discussed by [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following