[#ZBX-11193] Slow query performance on Administration -> Notifications page

Notifications page SQL performance improved. ( ~~ZBX-8924~~, The number of times that slow queries has decreased. (7 to 5) )
But still got performance problems with these SQL queries.

SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='0' AND e.object='0') AND a.clock>'1451228400' AND a.clock<'1473060439'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='1' AND e.object='1') AND a.clock>'1451228400' AND a.clock<'1473060439'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='1' AND e.object='2') AND a.clock>'1451228400' AND a.clock<'1473060439'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='2' AND e.object='3') AND a.clock>'1451228400' AND a.clock<'1473060439'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='3' AND e.object='0') AND a.clock>'1451228400' AND a.clock<'1473060439'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='3' AND e.object='4') AND a.clock>'1451228400' AND a.clock<'1473060439'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='3' AND e.object='5') AND a.clock>'1451228400' AND a.clock<'1473060439'

SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND a.clock>'1451228400' AND a.clock<'1473063352'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='1' AND e.object='1') AND a.clock>'1451228400' AND a.clock<'1473063352'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='1' AND e.object='2') AND a.clock>'1451228400' AND a.clock<'1473063352'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='2') AND a.clock>'1451228400' AND a.clock<'1473063352'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='3' AND e.object='0') AND a.clock>'1451228400' AND a.clock<'1473063352'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='3' AND e.object='4') AND a.clock>'1451228400' AND a.clock<'1473063352'
SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='3' AND e.object='5') AND a.clock>'1451228400' AND a.clock<'1473063352'

[ZBX-11193] Slow query performance on Administration -> Notifications page Created: 2016 Sep 12 Updated: 2019 Dec 10
Status:	Open
Project:	ZABBIX BUGS AND ISSUES
Component/s:	API (A), Frontend (F)
Affects Version/s:	2.2.14, 3.0.13
Fix Version/s:	None

[ZBX-11193] Slow query performance on Administration -> Notifications page Created: 2016 Sep 12 Updated: 2019 Dec 10