Re: iBatis, displaytag, and 10,000 rows

2004-03-15 Thread Andy Engle
Vic Cekvenich [EMAIL PROTECTED] wrote: That is bad design. Oh, I totally agree. There is no way I would want to shlep through 10,000 rows, nor would I want anybody else to have to do the same. But for some reason (as I mentioned in my initial post on this thread) my friend at work wanted to

iBatis, displaytag, and 10,000 rows

2004-03-11 Thread Andy Engle
Hi all, I am wondering if anybody has ever worked with a huge amount of data with iBatis and displaytag? I was showing off my little Struts application earlier to a buddy of mine here at work, and he asked if it would work well with 10,000 rows x 20-40 columns. Anybody ever worked with that

Re: iBatis, displaytag, and 10,000 rows

2004-03-11 Thread Richard Yee
Andy, iBatis has the queryForPaginatedList() to handle this situation. Check the iBatis documentation. queryForPaginatedList(): This very useful method returns a list that can manage a subset of data that can be navigated forward and back. This is commonly used in implementing user interfaces

Re: iBatis, displaytag, and 10,000 rows

2004-03-11 Thread Vic Cekvenich
That is bad design. You should querry the db and do TOP limit or a governor to prevent a run away qerry. If you do not find it... just re-run a better querry. .V Andy Engle wrote: Hi all, I am wondering if anybody has ever worked with a huge amount of data with iBatis and displaytag? I was