Hi Tim,
This is DSpace 3.2, XMLUI. The slowness seems to occur on every page, but ONLY
when the user is logged in. That makes sense given the eperson and epersongroup
queries, which couldn't run otherwise.
We will give http://www.yourkit.com/ a try and report back if we get
anywhere. I haven't done enough detailed analysis of the queries. But at first
blush, it looks like DSpace is gathering all the groups the eperson is a member
of (ditto all the parent groups) and then running another query for every other
eperson in each of those groups. Since we have eperson groups based on AD
groups, some of these can be very large (e.g., "Students"). You can see how
this could be a problem if the system was running a database query for every
eperson from every group the logged-in user is a member of. But like I said,
I'm not a hundred percent sure that is even what's happening.
To be continued....
Bill
-----Original Message-----
From: Tim Donohue [mailto:tdono...@duraspace.org]
Sent: Friday, February 28, 2014 11:05 AM
To: Ingram, William A; dspace-devel@lists.sourceforge.net
Subject: Re: [Dspace-devel] slowness when logged in
Hi Bill,
What version of DSpace is this? I recall this is XMLUI, just curious what
version we are looking at, and whether this may have been fixed in more recent
versions (I know in 1.7.0 especially there were some major performance
enhancements across the board...there's been other smaller improvements since
then as well)
Also might be worth understanding when this SQL log occurs. Is it for a single
person accessing a single Item page? Does this slowness *only* occur on
individual Item pages? Or is it elsewhere as well? It's hard to track down the
cause without that better understanding of what triggers this SQL.
I also wonder if using something like YourKit could help to track down the
cause here.. http://www.yourkit.com/
At a glance though, these SQL logs do seem odd. The logged in user information
should be cached in the user's session (so that it is not re-queried over and
over). But, this almost seems to be implying otherwise.
- Tim
On 2/26/2014 1:15 PM, Ingram, William A wrote:
> Hi all,
>
> I posted a similar question a few days ago to the tech list. When a
> user is logged into dspace, it takes six to eight seconds to load a
> page. So I took a SQL log dump for a single item page load. I am the
> only user on the system. The log is over 38,000 lines long; it starts
> at 11:08:15 and runs until 11:08:36. (see
> https://www.dropbox.com/s/1rlx4ryyfdz3r0t/ds-item-pg-sql.log)
>
> I see a lot of the same queries running over and over, hundreds of times:
>
> select * from epersongroup where eperson_group_id = $1
>
> SELECT * FROM epersongroup2eperson WHERE eperson_id= $1
>
> SELECT community.* FROM community, community2collection WHERE
> community.community_id=community2collection.community_id
>
> SELECT community.* FROM community, community2community WHERE
> community2community.parent_comm_id=community.community_id AND
> community2community.child_comm_id= $1
>
> It seems to be doing a lot more work than should be necessary for
> loading a single item page. And every time the user goes to another
> page, the process starts all over again.
>
> Any clues? Six to eight seconds of waiting for every page to load is
> unacceptable.
>
> Thanks!
>
> Bill
>
> --
>
> Bill Ingram
>
> Scholarly Communication and
>
> Repository Services
>
> University of Illinois at Urbana-Champaign
>
> 135 GELIC, MC274
>
> 1301 W. Springfield Ave.
>
> Urbana, IL 61801
>
> 217-333-4648
>
> wingr...@illinois.edu
>
>
>
> ----------------------------------------------------------------------
> -------- Flow-based real-time traffic analytics software. Cisco
> certified tool.
> Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
> Customize your own dashboards, set traffic alerts and generate reports.
> Network behavioral analysis & security monitoring. All-in-one tool.
> http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.
> clktrk
>
>
>
> _______________________________________________
> Dspace-devel mailing list
> Dspace-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-devel
>
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
