[ 
https://jira.duraspace.org/browse/DS-1426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Andrea Schweer updated DS-1426:
-------------------------------

    Description: 
Reported on dspace-tech by Ian Boston: 
http://dspace.2283337.n4.nabble.com/Statistics-question-tt4660426.html

If I attached  profiler and look into exactly what is happening.
1 request with the profiler connected takes 970ms
Some observations:
The statement cleanup from the SQL connection pool is about the most expensive 
operation at 110ms for 57 invocations.
To build the page takes 57 SQL queries, although none are expensive. (all bar 3 
report < 1ms).
UsageActionLogger.act consumes 2/3 of the time spent in the request and all of 
that is in SolrLogger.storeParents 

  was:
Reported on dspace-tech by Ian Boston: 
http://dspace.2283337.n4.nabble.com/Statistics-question-tt4660426.html:

If I attached  profiler and look into exactly what is happening.
1 request with the profiler connected takes 970ms
Some observations:
The statement cleanup from the SQL connection pool is about the most expensive 
operation at 110ms for 57 invocations.
To build the page takes 57 SQL queries, although none are expensive. (all bar 3 
report < 1ms).
UsageActionLogger.act consumes 2/3 of the time spent in the request and all of 
that is in SolrLogger.storeParents 

    
> SolrLogger performance issue
> ----------------------------
>
>                 Key: DS-1426
>                 URL: https://jira.duraspace.org/browse/DS-1426
>             Project: DSpace
>          Issue Type: Bug
>          Components: Statistics
>    Affects Versions: 1.8.2, 3.0
>            Reporter: Andrea Schweer
>            Assignee: Andrea Schweer
>              Labels: has-pull-request
>             Fix For: 3.1
>
>
> Reported on dspace-tech by Ian Boston: 
> http://dspace.2283337.n4.nabble.com/Statistics-question-tt4660426.html
> If I attached  profiler and look into exactly what is happening.
> 1 request with the profiler connected takes 970ms
> Some observations:
> The statement cleanup from the SQL connection pool is about the most 
> expensive operation at 110ms for 57 invocations.
> To build the page takes 57 SQL queries, although none are expensive. (all bar 
> 3 report < 1ms).
> UsageActionLogger.act consumes 2/3 of the time spent in the request and all 
> of that is in SolrLogger.storeParents 

--
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

------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to