[
https://jira.duraspace.org/browse/DS-659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18904#action_18904
]
Bojan Suzic commented on DS-659:
--------------------------------
Ok thanks for the comment. In meantime I have found there are similar issues
with some other functions in DSpace API in relation to REST API translation.
The problem is that it first loads a bunch of objects (whole collection) and
display only first 20 or the number user requires. Although there is caching
etc present, it is still not optimal in the regards to the performance and
resources consumption. I got some complaints wrt this issue by REST API testers.
I will consider then how it could reflect to other databases like Oracle. I am
considering also to resolve this issue on the REST API level e.g. by writing
new functions which will do DB querying (although it would be better to be
handled by DSpace API).
> Collection.findAll performance issue - offset and limit improvement
> -------------------------------------------------------------------
>
> Key: DS-659
> URL: https://jira.duraspace.org/browse/DS-659
> Project: DSpace
> Issue Type: Improvement
> Components: DSpace API
> Affects Versions: 1.7.0
> Reporter: Bojan Suzic
> Priority: Trivial
> Attachments: collection.java.add.txt
>
> Original Estimate: 1 hour
> Remaining Estimate: 1 hour
>
> During the REST API development it has been noticed that in some cases
> Collection.findAll may introduce performance issues, e.g. by working on big
> collections.
> For REST based browsing it is inefficient to preload big collection of say
> 20000 items and then return only first 100 items to the user. There are also
> other examples.
> In order to prevent those issues and optimize response I created two
> additional findall functions making possible to use offset and limit clauses
> during collections browsing. Also the simple function for returning number of
> collections in the system is added.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.duraspace.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
