[
https://issues.apache.org/jira/browse/OODT-216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tom Barber updated OODT-216:
----------------------------
Fix Version/s: (was: 0.8)
0.9
Push to 0.9
> Improve speed of pagination in all File Manager Catalogs by using lastIDs
> rather than scrollable cursors
> --------------------------------------------------------------------------------------------------------
>
> Key: OODT-216
> URL: https://issues.apache.org/jira/browse/OODT-216
> Project: OODT
> Issue Type: Improvement
> Components: file manager
> Environment: from JPL's internal JIRA
> Reporter: Chris A. Mattmann
> Assignee: Chris A. Mattmann
> Fix For: 0.9
>
>
> Currently, the filemgr's DataSourceCatalog leverages scrollable record cursor
> result sets to page over the returned results from an underlying JDBC
> database. With many records to page over (on the orders of 100s of 1000s),
> this operation is somewhat slow. I think that the speed of the operation
> could be improved using a filter criteria of e.g., taking the last ID of an
> ordered product list, and then using that as a filter criteria to define the
> starting point for paging, not bothering with scrollable cursors.
> This patch will provide such a capability as a configurable option for the
> DataSourceCatalog.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
