Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Pagination

 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am facing problem regarding pagination of the results. I am putting my problem more clearly to you.

I need to get the data from the database based on 6 values. The data which I get is very huge. This data needs to computed and I need to show the computed data to the user in seperate pages with each comprising 100 rows of data. The search criteria changes with every user.

In regard to my application configuration, I have a web server comprising UI, Action classes. These will communicate with the stateless session facade deployed in an App Server, and I can hit the database only through the App server.

Please provide me a solution so that I can hit the DB as less number of times as possible, and also that I need not store large chunks of data in the session (which is on the web server).

Thanks in advance.

P.S.: If I am wrong in posting this topic here, please move to the correct forum.
[ July 24, 2005: Message edited by: Hemanth Pallavajula ]
 
Ranch Hand
Posts: 293
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have a look at the Value List Handler pattern.
 
Hemanth Pallavajula
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Thanks Dave,

The pattern has shown me a new approach for handling this.
 
A teeny tiny vulgar attempt to get you to buy our stuff
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic