[ZBX-6087] More simple getting of actions list Created: 2013 Jan 09  Updated: 2017 May 30  Resolved: 2015 Apr 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.0.5rc1, 2.1.0
Fix Version/s: None

Type: Incident report Priority: Minor
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: patch, performance, redundancy
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Text File action_hints.patch    
Issue Links:
Duplicate
duplicates ZBX-6389 Slow queries in Dashboard widgets (Sy... Closed

 Description   

The issue is related to Actions column on Monitoring->Events page and Last 20 issues widget.
We execute four queries per event (which have any actions) instead of one.

Attached patch is solve the problem. Look comments for getting more information about improvement.



 Comments   
Comment by Alexey Pustovalov [ 2013 Jan 09 ]

Old page Monitoring->Events:

******************** Script profiler ********************
Total time: 1.552287
Total SQL time: 1.429751
SQL count: 101 (selects: 61 | executes: 40)
Peak memory usage: 15.5M
Memory limit: 2048M

New page Monitoring->Events:

******************** Script profiler ********************
Total time: 1.544134
Total SQL time: 1.421835
SQL count: 77 (selects: 37 | executes: 40)
Peak memory usage: 15.5M
Memory limit: 2048M

That is related to Last 20 issues also... so number of queries reduced in four ones.

Comment by Alexander Vladishev [ 2015 Apr 11 ]

I close the issue as duplicate of ZBX-6389.

Generated at Thu Mar 28 18:10:49 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.