Why not develop an DAO component that you can cache your data on server side. If user sort the column, you just sort the cached data. You needn't search again every time. Or if the data is huge, you can paging them. Maybe firstly cached 5 or less pages,if it's need,call database to get the next 5 pages.
Wish it helpful. Dennis --__--__-- ----- Original Message ----- From: "Uthiresh Narayanan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 7:26 AM Subject: Re: need clarification > 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". > =========================================================================== 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".
