Summary

Recently there were implemented multiple permission check performance improvements. Unfortunately there are multiple fronted areas (like problems view, problems widget, etc) where these changes did not brought expected improvements due to "NOT EXISTS" statement in SQL queries.

Use case

1. As a Zabbix restricted user I want to open problems widget or search problems view (1 month period with tags) in less than 3 seconds.

Expected result

Improved permission check database structure for faster query execution.