This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Performance tuning

 
mama thabattu
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
am using Jboss 4 as a server, Oracle 9i as backend and java. i have one report in which procedure will send 100000 records.When am running the report for the first time it takes around 55seconds to get the response. the same report for the different type input(output will be different but same amount of records) it takes 4 seconds. For the next iteration it takes 3seconds.
am using callableStatements.When i tried to print the time where it takes so much time, i found getting the object from the cursor and iterating the resultset first time takes long time.
first i thought it is bcoz of cache. But the second time iteration is for entirely different inputs.

Advanced thanks for your help.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic