Hi All, Can Anybody help ? I have a Oracle 9i table named Contacts which contain about 10000 records. I need to show them in a JSP page ordered by last name or first name or in any other order (as per user request). But only 100 records should be shown at a time. User can click "Previous" or "Next" links to see more records ( as in Google/Yahoo search )
I have done this by creating a temporary table. Records are sorted and kept in the temporary table . But this seems to be a very slow and inefficient method. ( Each request involves a select from the original table, creation of tempory table, insertion into temp table and finally select from temp table. ) Can anybody suggest a better approach ? Thanks Joshy =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com