File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes ResiltSet Holdability Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ResiltSet Holdability" Watch "ResiltSet Holdability" New topic

ResiltSet Holdability

Raj chiru
Ranch Hand

Joined: Aug 12, 2008
Posts: 142
how ResultSet object(cursor) Holdability feature will increase Application performance?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32793

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: ResiltSet Holdability
It's not a secret anymore!