You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Andy Engle <st...@andyengle.com> on 2004/03/11 22:38:12 UTC
iBatis, displaytag, and 10,000 rows
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 much data with iBatis/displaytag before? If so, how did it
work out for you?
Thanks,
Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: iBatis, displaytag, and 10,000 rows
Posted by Andy Engle <st...@andyengle.com>.
Vic Cekvenich <ce...@portalVU.com> 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 know if it could be done. Hopefully he'll
never be doing this 10,000 row business.
Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: iBatis, displaytag, and 10,000 rows
Posted by Vic Cekvenich <ce...@portalVU.com>.
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 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 much data with iBatis/displaytag before? If so, how did it
> work out for you?
>
>
> Thanks,
> Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: iBatis, displaytag, and 10,000 rows
Posted by Richard Yee <ry...@yahoo.com>.
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 that only display
a subset of all of the available records returned from
a query. An example familiar to most would be a web
search engine that finds 10,000 hits, but only
displays 100 at a time. The PaginatedList interface
includes methods for navigating through pages
(nextPage(), previousPage(), gotoPage()) and also
checking the
status of the page (isFirstPage(), isMiddlePage(),
isLastPage(), isNextPageAvailable(),
isPreviousPageAvailable(), getPageIndex(),
getPageSize()). Although the total number of records
available
is not accessible from the PaginatedList interface,
this should be easily accomplished by simply executing
a second statement that counts the expected results.
Too much overhead would be associated with the
PaginatedList otherwise.
Regards,
Richard
--- Andy Engle <st...@andyengle.com> wrote:
> 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 much data with iBatis/displaytag before?
> If so, how did it
> work out for you?
>
>
> Thanks,
> Andy
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> struts-user-help@jakarta.apache.org
>
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org