File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes Huge resultSet help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Huge resultSet help" Watch "Huge resultSet help" New topic
Author

Huge resultSet help

antonio saginario
Greenhorn

Joined: Nov 18, 2001
Posts: 5
hi,
I have a serious problem with very very large Recordset data (say 25 milion record).
I have noticed that store in memory (using Vector p.e.)this kind of data is more expensive.
Another solution is to take open a scrollable ResultSet (JDBC 2.0) but Oracle Documentation say that JDBC cache on memory all the row.
My application consists of several servlets which on user request produce dynamic SQL queries. The results are shown to the user on HTML pages by a pagination in the memory.
Help me to find a good solution for this problem
Best Wishes.
Jim Yingst
Wanderer
Sheriff

Joined: Jan 30, 2000
Posts: 18671
I suggest you check out this thread. Good luck.


"I'm not back." - Bill Harding, Twister
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Huge resultSet help
 
Similar Threads
any free type 4 driver ?
OutOfMemoryError when using ResultSet
Performance tunning using J2EE
help needed.. Websphere performance tuning
ResultSet is not scrollable problem - WAS 3.5 (Very Urgent please)