• 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
Marshal
Posts: 34210
341
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic