Hello,
I’m using OJS 2.4.8 and when I click the “Notify Users” link in “Editor” page it’s taking too long to load, I realized that the query bellow is the responsible for the delay, the MySQL Workbench shows “890 row(s) returned in 653.414 sec”.
SELECT DISTINCT
CAST(’’ AS CHAR) AS url,
0 AS author_id,
0 AS submission_id,
aa.email AS email,
0 AS primary_contact,
0 AS seq,
aa.first_name,
aa.middle_name,
aa.last_name,
CASE WHEN asl.setting_value = ‘’ THEN NULL ELSE SUBSTRING(asl.setting_value FROM 1 FOR 255) END AS affiliation_l,
CASE WHEN asl.setting_value = ‘’ THEN NULL ELSE asl.locale END AS locale,
CASE WHEN aspl.setting_value = ‘’ THEN NULL ELSE SUBSTRING(aspl.setting_value FROM 1 FOR 255) END AS affiliation_pl,
CASE WHEN aspl.setting_value = ‘’ THEN NULL ELSE aspl.locale END AS primary_locale,
CASE WHEN aa.country = ‘’ THEN NULL ELSE aa.country END AS country
FROM authors aa
LEFT JOIN author_settings aspl ON (aa.author_id = aspl.author_id AND aspl.setting_name = ‘affiliation’ AND aspl.locale = ‘pt_BR’)
LEFT JOIN author_settings asl ON (aa.author_id = asl.author_id AND asl.setting_name = ‘affiliation’ AND asl.locale = ‘pt_BR’)
LEFT JOIN authors aa2 ON (aa.email=aa2.email AND aa.author_id < aa2.author_id)
JOIN articles a ON (a.article_id = aa.submission_id AND a.status = 3)
JOIN published_articles pa ON (pa.article_id = a.article_id)
JOIN issues i ON (pa.issue_id = i.issue_id AND i.published = 1)
JOIN sections s ON (a.section_id = s.section_id)
JOIN journals j ON (a.journal_id = j.journal_id)
WHERE a.journal_id = ‘6’
AND (aa.last_name IS NOT NULL AND aa.last_name <> ‘’)
AND ((s.hide_author = 0 AND a.hide_author = 0) OR a.hide_author = 2)
AND aa2.email IS NULL
ORDER BY aa.last_name, aa.first_name
There’s something that I can do in my configuration?