You are viewing the PKP Support Forum | PKP Home Wiki

Server is responding so slowly - OJS 2.3.8

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Server is responding so slowly - OJS 2.3.8

Postby carlaferreira » Tue Feb 11, 2014 11:05 am

We wonder why our server is responding so slowly. Tests were performed and showed that the time delay of many magazines is very slow (more than 3 minutes to respond).
Actions such as selecting reviewer (and all on evaluation), select items in the queue processing / editing, e-mails are those that are slow. Our version is 2.3.8. We know that the size of free memory and server are in accordance with the settings and demand.

The systems analyst made ​​a brief analysis and found that indeed there is a request made repeatedly in the database that takes a long time to be processed . SQL' code is as follows:

SELECT DISTINCT CAST ('' AS CHAR ) AS url , 0 AS author_id , 0 AS submission_id , CAST ('' AS CHAR ) AS email , 0 AS primary_contact , 0 AS seq, aa.first_name , aa.middle_name , aa.last_name , asl.setting_value affiliation_l AS, asl.locale , aspl.setting_value affiliation_pl AS, AS aspl.locale primary_locale , aa.country FROM authors aa LEFT JOIN author_settings ASPL ON ( aa.author_id = aspl.author_id AND aspl.setting_name = ' affiliation ' AND aspl.locale = ' en_US ' ) LEFT JOIN ON author_settings asl ( aa.author_id = asl.author_id AND asl.setting_name = ' affiliation ' AND asl.locale = ' en_US ' ) LEFT JOIN articles ON ( a.article_id = aa . submission_id ) LEFT JOIN published_articles pa ON ( pa.article_id = a.article_id ) LEFT JOIN issues ON i ( pa.issue_id i.issue_id = ) WHERE 1 = i.published aa.submission_id AND AND pa.article_id = a.article_id = a . article_id AND a.status = 3 AND ( aa.last_name IS NOT NULL AND aa.last_name < >'' ) AND LOWER ( aa.last_name ) LIKE LOWER ( '%' ) ORDER BY aa.last_name , aa.first_name LIMIT 10100 25

Function that generates one slow request:
is getAuthorsAlphabetizedByJournal , the classes / article / AuthorDAO.inc.php file.

Description of function , according to the file itself :

" Retrieve all published authors for a journal in an associative array by the first letter of the last name "
" Keys Will Appear in sorted order . Que Note if journalId is null , alphabetized authors for all journals are returned . "

What you suggest in this case to be done?

I created a thread in the Technical OJS and informed me that it certainly has nothing to do with the slowness of the system.
Link to this topic: http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=11577&p=44500#p44500

We know we have to update the version, but is there something to be done before that, to solve this system slowdown?
Posts: 16
Joined: Thu Mar 24, 2011 8:57 am

Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest