File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to make pagination?

 
Mishra Anshu
Ranch Hand
Posts: 224
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
This is a very common problem for any web application.
I need to make search which may result in thousands of records.
So, accordingly the page will be displayed (say, 10 results per page).

1st Approach:-
I make the query to hit database everytime a search is requested.So, for every page a search is unnecessarily performed.

2nd Approach:--
I store the result in the meory. So, say 1000 record have been searched and stored in the memory. So, not for every page result a new search is
required. But..., here I can't predict the search size, so I may get OutOFMemoryException.

3rd Approach :-
Since my DB is Oracle. I want to make a temp table to store the result od the search. But in Oracle , I think there is only Global Temp table, So, How it can handle the search , if there are multiple persons making the search at the same time.

:roll:
 
kri shan
Ranch Hand
Posts: 1453
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try thru CachedRowSet
 
Mishra Anshu
Ranch Hand
Posts: 224
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can it avoid the OutOfMemory exception???
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mishra,
For Oracle, look into materialized views. It's a caching technology on the db server.

If you are writing your own (options 1/2), consider whether you need all the results. A lot of users abandon the search without paging at all. In that case you only need the first 20 or so records. Getting more is a waste of resources.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mishra,
Since you are using Oracle, go to the Ask Tom Web site, and do a search for "pagination".

Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic