Hi All ,
my requirement is to do a search in the database , and fetch large number of records , but then those records are to be displayed page wise in my web pages , Now Can i fetch all the records from the database and store in my Application Server Weblogic 6.1 and show it page by page , Wont this cause some performance or memory issues , or are there any other ways ?
Help me out
Thanks .
-
Weblogic 6.1 , storing all Database Results , Paging Display... (1 messages)
- Posted by: Asif Equbal
- Posted on: January 14 2002 00:10 EST
Threaded Messages (1)
- Weblogic 6.1 , storing all Database Results , Paging Display... by Chris Knoll on January 16 2002 11:42 EST
-
Weblogic 6.1 , storing all Database Results , Paging Display...[ Go to top ]
- Posted by: Chris Knoll
- Posted on: January 16 2002 11:42 EST
- in response to Asif Equbal
Consider using the ValueList, ValueObject, ValueListAssembler and ValueListIterator pattern. Depending on how large your results are, you could either have the ValueListAssembler be 'smart' and cache objects that are created, or you could make it simpler and rely on the database server to maintain the state of your result set, and have the value list assembler or value list get the next page of results as needed.
-Chris