I once brought back 100,000 rows and made my users page through them 20 at a time. It was somewhere between the 4500 and 4501 time the user was clicking next that we went bankrupt.
Some blame this and not the corruption for the fall :) Just FYI, Burke -----Original Message----- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 9:30 AM To: Struts Users Mailing List Subject: Struts and Large ResultSet Hi, Has any one handled lasgre result set using struts, like my sql query returns ablut 100,000 records but i want to show only 20 records per page, and then when the user clicks next, want to show the next 20 .. A$HI$H --------------------------------- Do You Yahoo!? HotJobs, a Yahoo! service - Search Thousands of New Jobs ********************************************************************** This e-mail is the property of Enron Corp. and/or its relevant affiliate and may contain confidential and privileged material for the sole use of the intended recipient (s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender or reply to Enron Corp. at [EMAIL PROTECTED] and delete all copies of the message. This e-mail (and any attachments hereto) are not intended to be an offer (or an acceptance) and do not create or evidence a binding and enforceable contract between Enron Corp. (or any of its affiliates) and the intended recipient or any other party, and may not be relied on by anyone as the basis of a contract by estoppel or otherwise. Thank you. ********************************************************************** -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
