i have implemented some thing similar but using stored procedures.. ... i just requery and send the order by column name ...
it will take the same time as the search... hope this helps... uthiresh -----Original Message----- From: A mailing list for Enterprise JavaBeans development [mailto:EJB-INTEREST@;JAVA.SUN.COM]On Behalf Of Kesavanarayanan, Ramesh (Cognizant) Sent: Thursday, October 17, 2002 2:49 PM To: [EMAIL PROTECTED] Subject: need clarification Hi all, Forgive me if this is off-topic In my application I have the following scenario. Let me know the fine approach tothis situation. Scenario - 1 --------------- 1) The user selects a file consisting of various auto rates. 2) The system then reads this file (.csv , .xls) andfor each of the rows in the file, the system validates certain rules. 3) The system then displays the whole file in the browser in table format. 4) All those rows which do not satisfy the rules will be highlighjted whereas the other rows will be displayed as such. 5) The user can select one of the row and verify the autorates. Scenario -2 I have a search screen. The user inputs the search criteria and clicks Search button. The system retrieves the rows and displays them in multiple pages 10 rows in each page. The problem is that each row in a single page has 5 columns. Each column has 2 images one each for ascending and descending. Default the order is Ascending. When the user clicks on the descending button of a particular column in a page, I need to display the whole page in descending order. This has to be done for all the columns in all the rows of all the pages. My problem is basically about the performance issue. My client wants the whole thing to be displayed in 2 minutes. Kindly let me know your esteemed suggestions and approach to fit this.... Regards Ramesh Kesavanarayanan =========================================================================== 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".
