This is indeed probably not a hardware issue but related to the new
database abstraction layer (Hibernate), similar to
https://jira.duraspace.org/browse/DS-3004

Can someone share the profiling report of a case where it runs really slow?


[image: logo] Tom Desair
250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586
Esperantolaan 4, Heverlee 3001, Belgium
www.atmire.com
<http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=tomdesair>

2016-12-02 16:11 GMT+01:00 <wltant...@gmail.com>:

> I have similar specs, except for ssd drives:
>
> 8 CPUs, GenuineIntel, 2299.998 MHz
> 32 GB with -Xmx16384m
> tomcat 8,0.33
> postgresql-9.5.1
>
> Like I said, this same machine cruised nicely with v5.6.  Page loads are
> subjectively slower across the board, but the Submission page load time is
> an upgrade killer.
>
> On Friday, December 2, 2016 at 4:08:02 AM UTC-6, Joan Caparros wrote:
>>
>> We are experiencing the something similar but in all our repository
>> (except the home page), almost all pages in DSpace 6x takes between 6s to
>> 60seconds, we have tried to increase the memory of the tomcat, changed the
>> SO (Centos7 to Ubuntu), upgrading tomcat (8.0.5 to 8.5), giving more cpus,
>> changing data to ssd hard drive... all without a signigicant improvements
>> of performance.
>>
>> Our configs are:
>>
>> Vcpus : 8 (GenuineIntel  2099.998MHz)
>>
>> Tomcat (8.5.8) config:  -Xmx4072M -Xms512M -XX:PermSize=256M
>> -XX:MaxPermSize=512m
>>
>> Items: arroung 120k
>>
>> Now we have in production DSpace 3_x and this situation is preventing us
>> from upgrading also.
>>
>> Bests
>>
>> Joan
>> El 01/12/16 a les 22:15, wlta...@gmail.com ha escrit:
>>
>> In DSpace 6x, it takes an intolerable 10 minutes (!!!) to populate the
>> Select Collection drop-down in my instance when logging in as a regular
>> user as opposed to an administrator.
>>
>> I can add hardware details if anybody is interested, but I'm pretty sure
>> it's not the problem -- this is a beefy machine that hummed along nicely
>> with version 5.x...
>>
>> We have a little over 1000 collections in our repository, and we use
>> shibboleth for authentication so findAuthorizedPerformanceOptimize is
>> set to it's default of false.
>>
>> Some rudimentary profiling suggests that the isAdmin() call in
>> authorize() is the bottleneck.  In a recent test (pretty typical), the
>> findAuthorized() function takes 704,040 ms to return.  The time spent in
>> the isAdmin() call amounts to 590,691 ms, or about 83% of the time.
>> Another bottleneck within this bottleneck is the recursive call to
>> isAdmin(parent collection) -- about 400,000 ms.  Clearly there is a lot of
>> waste in this call because many many collections will be tested over and
>> over.  In our case, we have a single community that is the ancestor of
>> every community/collection, and isAdmin() winds up being called against it
>> 1012 times -- same as the number of collections in the repository -- and
>> 1011 of them are redundant.
>>
>> As a further test, I have short-circuited isAdmin() to return false
>> immediately.  The results in the rendering of the drop-down in about 94,000
>> msec.  Still way too long, but a drastic improvement.
>>
>> When logging in as an administrator, isAdmin() returns rather quickly and
>> the list is populated much quicker as well.  But for the everyday user, the
>> performance is a big red light preventing us from upgrading.
>>
>> Sorry, this is simply stating the problem with no solution.  But has
>> anybody else with a similarly sized repository experienced this slow down?
>>
>> Regards,
>> Bill
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dspace-tech...@googlegroups.com.
>> To post to this group, send email to dspac...@googlegroups.com.
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>> --
>> .........................................................................
>>
>> Joan Caparrós
>> Tècnic de Projectes
>> Consorci de Serveis Universitaris de Catalunya (CSUC)
>>
>> Gran Capità, 2 (Edifici Nexus)•08034 Barcelona
>> T.93 551 6204•F.93 205 6979•joan.c...@csuc.catwww.csuc.cat •Twitter 
>> @CSUC_info•Facebook•Linkedin
>> Subscriu-te al butlletí; (www.csuc.cat/butlleti)
>> .........................................................................
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Reply via email to