Slow database query OJS3

Software Support
1

The following query runs slow and consumes a lot of server resources.
Can someone tell me how to resolve this problem?

SELECT COUNT(*) FROM (SELECT DISTINCT u.*,
				COALESCE(ugl.setting_value, ugpl.setting_value) AS user_given,
			CASE WHEN ugl.setting_value <> '' THEN ufl.setting_value ELSE ufpl.setting_value END AS user_family
--
				LEFT JOIN user_settings usfs ON (usfs.user_id = u.user_id AND usfs.setting_name = 'familyName')

			WHERE	1=1 AND ug.context_id = 1) _ADODB_ALIAS_;

What I tried to resolve the issue:
don’t know how to resove

Application Version - e.g., OJS 3.1.2:
3.1.2.4

2

Your version is some years old.
Did you try to upgrade? It will probably be fixed.

Cheers,
m.

1 Like