Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Resulset performance problem.

 
Shailesh Bhatsangave
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

i have problem when iterating through resultSet.next()
in while loop , it is taking too much time for reading 3000
results. i am adding all the data into list.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the bottleneck? Is it CPU bound or memory bound? If its neither, how good is the network between the database and your app? And what sort of data is in your ResultSet?
[ December 19, 2008: Message edited by: Paul Sturrock ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Shailesh,
Welcome to JavaRanch!

How much time is "too much time"? Have you confirmed the query itself doesn't take too long and that you are using all the columns that get returned?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic