Issue Type: Improvement Improvement
Affects Versions: 3.2, 1.8.2
Assignee: Unassigned
Components: SWORD
Created: 14/Oct/13 4:47 PM
Description: As I drill down ServiceDocumentManager:

I've reach to this method to get all collections (findAll):
dspace-api/src/main/java/org/dspace/content/Collection.java

That is performing a query to get all collections:
SELECT * FROM collection ORDER BY name;

And for each collection in the list, it's getting the users actions permissions (getPoliciesActionFilter):
dspace-api/src/main/java/org/dspace/authorize/AuthorizeManager.java

SELECT * FROM resourcepolicy WHERE resource_type_id= ?
AND resource_id= ? AND action_id= ?;

In our case, we have a repository that has 1229 collections.
When the user performs the request: /sword/servicedocument

the process takes near 43s to retrieve the response, which is a long time for waiting for an anwser. Is there any workaround for this?
Environment: CentOS release 5.7
Project: DSpace
Priority: Minor Minor
Reporter: Paulo Graça
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to