All,
First of all, I want to thank everyone who has worked on DisplayTag for once
heck of a product! It for sure is the one J2EE tool i couldnt live without
on any web project. My team has been using it on several different projects,
and we would like to get some input on something I am sure many of us have
faced, and on searching the archives, I see some patches have been submitted
for(DISPL-14,Issue #1026408 ).
We have a view which includes calls to several stored procedures to get data
for some of its columns, like so :
"select col_name,col_name....., my_package.myFunc1(param),
my_package.myFunc2(param) from table1;
Table1 is a large table with more than 100,000 rows, and we need to display
a query against this view in our JSP. We have been using DisplayTag for
this, but as DisplayTag needs a static list to iterate over, we are left
with having to query the view for all the rows, thus forcing execution of
the stored procedure calls for each of the 100,000 rows even if our page set
is 100 rows. Before we start writing any custom code, I wanted to ask if
theres anything out there that will already meet our needs.
I searched the archives and came across an entry in JIRA( DISPLAY-14), which
talks about the same. The approach suggested there is to pass in offsets to
the database itself, and use the LIMIT option in SQL to limit the number of
rows fetches/calculated at the database level. I want to try to use it, but
am unable to figure out where to get the jar file/docs etc.
Any help/pointers on this issue will be highly appreciated.
Thanks again!
Vik,
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
displaytag-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/displaytag-user
