Project: XPages Extension Library (Managed by Philippe Riand, Niklas Heidloff, Dave Delay, Akihiro Kosugi, Maire Kehoe, Tony McGuckin, John Piermarini, Martin Donnelly, James Quill, Darin Egan, Padraic Edwards, Andrejus Chaliapinas, Lorcan McDonald, Simon McLoughlin, Paul Hannan)
Paging when using xe:jdbcQuery
Alex L Rasmussen on 01/19/2012 at 04:33 AM
I am evaluating XPages for an application which must access both Notes data as well as data from several DB2 tables and show them in view controls. Using the RDBMS features in the extension library, I can get my DB2 data without problems.
I am, however, worried about performance, because I need to access tables with 500000+ rows. In the presentation "XPages Goes Relational", Philippe Riand states that the jdbcQuery data source uses the JDBC result set and optionally maintains a cache. But returning half a million rows seems a little drastic, considering that the user will page through the data 25 or 50 rows at a time. Is there anyone out there already using the functionality, who can shed some light on the performance?
I would like to use a select statement that specifies the starting row and limits the number of results returned to Domino and passing them to the query as parameters, e.g.: SELECT * FROM ORDTAB WHERE ROWNUM > ? FETCH FIRST ? ROWS ONLY
This would require the pager to expose the selected page to be used as a SQL parameter (I can get the result set size by providing a listbox for user selection) and re-issue the query prior to refreshing the view control. But it doesn't look like the pager exposes anything I can use.
Does anybody know of a pager that will let me do this, or do I need to roll my own?
Any thoughts or help will be highly appreciated. Thanks,
|Entered 19-Jan-2012 4:33 by Alex L Rasmussen. Last Modified <none> by Niklas Heidloff.|
Check out other projects