• Post Reply Bookmark Topic Watch Topic
  • New Topic

ResiltSet Holdability

 
Raj chiru
Ranch Hand
Posts: 142
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi....
how ResultSet object(cursor) Holdability feature will increase Application performance?
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36027
431
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Raj,
I suppose the answer is that by not having to redo the query, you save time. However, this is dependent on the scenario and involves a memory tradeoff. So it depends on whether it will increase performance.
 
Of course, I found a very beautiful couch. Definitely. And this 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!