File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Huge resultSet help

 
antonio saginario
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 18671
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I suggest you check out this thread. Good luck.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic