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
