• 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
Sheriff
Posts: 36031
432
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?
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!