Type: Problem report
Resolution: Won't fix
Affects Version/s: 4.2.6
Fix Version/s: None
Component/s: Frontend (F)
Sprint:Sprint 57 (Oct 2019), Sprint 58 (Nov 2019), Sprint 59 (Dec 2019), Sprint 60 (Jan 2020), Sprint 61 (Feb 2020), Sprint 62 (Mar 2020), Sprint 63 (Apr 2020), Sprint 64 (May 2020), Sprint 65 (Jun 2020), Sprint 66 (Jul 2020)
We suggest to optimize SQLs, where permission is checked:
this SQL takes more than a minute and on bit sets od data - even longer, 5-10 minutes
What is optimized:
In original query, this block:
This change decreased time to 5 seconds.
We use Oracle as zabbix db.