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
