Rick, Will, I use hibernate as well along with the built-in caching mechanisms which work really great. The only sql I write are custom searches and stuff like that.
The issue really boiled down to applying custom code to display tag in order to handle a what looks like a full result set in memory, when I'd actually only have a subset. However, I'd still need the pagaing to work just as if the entire result set was in memory. I don't have any problem hacking a solution in, but before I do that, I was really looking to see if someone had a quick or really smart solution that they've added to display tag. I did go thru the JIRA issues regarding db paging as well, but they either seemed a little too involved (at the point I was looking at them) or they got involved with other issues. So, ok, well, thx anyway. If no one has really come forward with a 'this is the way to do it and I'll have code checked in for release X' then I'll prob just figure it out myself. Or spend a little more time on the already open JIRA issues. Thx, - jason --- Will Glass-Husain <[EMAIL PROTECTED]> wrote: > I use Hibernate and Display Tag. Hibernate does > help with many performance > issues. Paging of large result sets was still an > issue. I came up with a > custom set of modifications to handle this. > > There's a couple of patch/proposals on this issue in > JIRA. (including one > from me). Might be worth looking into, seeing if > any apply. > > WILL > > ----- Original Message ----- > From: "Rick Herrick" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Saturday, January 08, 2005 11:22 AM > Subject: RE: [displaytag-user] Db paging > > > Jason, > > Another possibility is looking into Hibernate to > handle the result set. > Hibernate lets you create XML templates that > describe your data handling > classes. Hibernate then creates Java code to handle > all the db > transactions. It's really easy to use these classes > as beans that can be > integrated into Struts and display tag usage. > Hibernate is specifically > optimized to minimize database transaction overhead > and resource usage > without requiring a lot of work on the part of the > developer. > > You can get info on Hibernate at > http://www.hibernate.org. It's really easy > to use, IMO, and there are plug-ins for Eclipse, > IntelliJ, and some others > for creating and managing your bean definitions. > > I'm not connected with Hibernate, just a happy user > :^) > > Rick Herrick > [EMAIL PROTECTED] > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > [mailto:displaytag-user- > > [EMAIL PROTECTED] On Behalf Of Jason > Lee > > Sent: Saturday, January 08, 2005 7:24 AM > > To: [email protected] > > Subject: Re: [displaytag-user] Db paging > > > > Yah I did before I started using displaytag and > > decided that it wasn't the approach I wanted to > take. > > Guess I'll figure something out. > > > > Thx, > > > > - jason > > > > --- Matt Raible <[EMAIL PROTECTED]> wrote: > > > > > You might checkout http://valuelist.sf.net. > > > > > > Matt > > > > > > On Jan 7, 2005, at 9:09 PM, Jason Lee wrote: > > > > > > > Hi, > > > > > > > > I know this was mentioned a few months back, > but I > > > was > > > > wondering what solutions people have come up > with > > > to > > > > do paging through (possibly) large result > sets. > > > This, > > > > of course, also involves keeping a number of > > > actual > > > > records somewhere (which isn't really a big > deal) > > > > along the lines of count(*) from table. > > > > > > > > I've been playing around with a few > approaches, > > > but > > > > wanted to see if anyone else has possibly come > up > > > with > > > > a better solution before I go putting a bunch > of > > > > custom code in my app. > > > > > > > > Any suggestions greatly appreciated and TIA, > > > > > > > > jason > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > Read only the mail you want - Yahoo! Mail > > > SpamGuard. > > > > http://promotions.yahoo.com/new_mail > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > The SF.Net email is sponsored by: Beat the > > > post-holiday blues > > > > Get a FREE limited edition SourceForge.net > t-shirt > > > from ThinkGeek. > > > > It's fun and FREE -- well, > > > almost....http://www.thinkgeek.com/sfshirt > > > > > _______________________________________________ > > > > displaytag-user mailing list > > > > [email protected] > > > > > > > > > > https://lists.sourceforge.net/lists/listinfo/displaytag-user > > > > > > > > > > > > > > > ------------------------------------------------------- > > > The SF.Net email is sponsored by: Beat the > > > post-holiday blues > > > Get a FREE limited edition SourceForge.net > t-shirt > > > from ThinkGeek. > > > It's fun and FREE -- well, > > > almost....http://www.thinkgeek.com/sfshirt > > > _______________________________________________ > > > displaytag-user mailing list > > > [email protected] > > > > > > https://lists.sourceforge.net/lists/listinfo/displaytag-user > > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail - Helps protect you from nasty > viruses. > > http://promotions.yahoo.com/new_mail > > > > > > > ------------------------------------------------------- > > The SF.Net email is sponsored by: Beat the > post-holiday blues > > Get a FREE limited edition SourceForge.net t-shirt > from ThinkGeek. > > It's fun and FREE -- well, > almost....http://www.thinkgeek.com/sfshirt > > _______________________________________________ > > displaytag-user mailing list > > [email protected] > > > https://lists.sourceforge.net/lists/listinfo/displaytag-user > > > > > ------------------------------------------------------- > The SF.Net email is sponsored by: Beat the > post-holiday blues > Get a FREE limited edition SourceForge.net t-shirt > from ThinkGeek. > It's fun and FREE -- well, > almost....http://www.thinkgeek.com/sfshirt > _______________________________________________ > displaytag-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/displaytag-user > > > > ------------------------------------------------------- > The SF.Net email is sponsored by: Beat the > post-holiday blues > Get a FREE limited edition SourceForge.net t-shirt > from === message truncated === __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail ------------------------------------------------------- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt _______________________________________________ displaytag-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/displaytag-user
