Your problems were solved with display tag already. Could you search in the archive for "external sort" or "partial list"? If you find nothing, I'll tell you what I did.
>>> [EMAIL PROTECTED] 9/26/2005 2:57:21 AM >>> I'm facing the same problem, cos my data runs across pages, there is a nice javascript available, but I'm looking at the feasibility of clubbing them together for optimal use... http://www.activewidgets.com/grid/ Check this might be of use. Regards Varun Mehta Phone: (020) 3023 4656 Websites: * http://varun.cjb.net [HTML] * http://varuninfo.cjb.net [Blogged] * http://varunmehta.cjb.net [Flash] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* imagination is more important than knowledge - albert einstein *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nicolas Clemeur Sent: Monday, September 26, 2005 12:14 PM To: [email protected] Subject: [displaytag-user] Large data set treatment by the database Hello everyone, I have just discovered the displaytag library and it looks really good. I am investigating how I can use it in my current projects and I came across some questions. I have tried to look in the archive but, could not really find any answers. Sorry if this information is availabel somewhere else. The data I am displaying are coming from a database and can contain a large number of rows. So we are not retrieving all the rows every time a page a is displayed which would be too expensive for the web server. We are retrieving rows 1 to 20 for page 1, 21 to 40 for page 2, etc... This approach looks unfortunatelly incompatible with the sorting/paging functionnality of displaytag. The only way I can see to solve this problem is to have more flexibility in the way the sorting/paging are working. For example, it would be nice to be able to specify in the <display:table> attributes the name of a parameter that would containt the page number that should be retrieved from the database (I think this is probably already feasible by customising the links that are created for the navigation). No, the only piece missing here, is that the application should be abble provide to the tag the total number of rows that is in this dataset so that displaytag can build the navigation links. I don't think that this is possible currently? What about something like a PageNavigationDecorator that would extend the default implementation. For sorting, I have the same problem. Since I am not retrieving all the rows, I need to do the sorting in the database it-self (which is much more efficient anyway), so again, it would be nice to be abble to specify the name of parameters where the webapp should look at for the column to sort as well as the order to sort. Maybe the easiest and more flexible way to achieve this is to have the possibility to define the <th> with an additional tag <table:header> nested inside <table:column> so that we can completely customise the <th> tag if necessary. In the same way, it would be nice if we could add javascript event handler to the headers or cells separately... Cheers Nicolas ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ displaytag-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/displaytag-user ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ displaytag-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/displaytag-user ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ displaytag-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/displaytag-user
