The project I am working on has some search pages that can return
hundreds of results. I want the user to be able to view a subset of
these results and page forward and backward. Just about every site on
internet paginates search results, but no one I know has any idea how it
is done. I assume most of the dirty work and cache-ing are controlled at
the database, and manipulated via JDBC, but I can't find a best
practice. I am architecting an EJB application, and our database is
Oracle 8i.
So the question is this: what is the best way of paginating these
results? Are there standard SQL types or JDBC methods that best control
this behavior, maximizing performance (such as not returning all the
results to the application server at once, and not having to regenerate
the query from scratch at each request)?
--
--------------
neil poska, supersonic enemy of evil
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
