[#ZBX-7170] Using item.get with output extend in the frontend

[ZBX-7170] Using item.get with output extend in the frontend Created: 2013 Oct 18 Updated: 2017 May 30 Resolved: 2013 Oct 23
Status:	Closed
Project:	ZABBIX BUGS AND ISSUES
Component/s:	Frontend (F)
Affects Version/s:	2.1.8
Fix Version/s:	2.1.9, 2.2.0

Type:

Incident report

Priority:

Major

Reporter:

Pavels Jelisejevs (Inactive)

Assignee:

Ivo Kurzemnieks

Resolution:

Fixed

Votes:

Labels:

frontend, history, item, performance

Remaining Estimate:

Not Specified

Time Spent:

Not Specified

Original Estimate:

Not Specified

Description

After ~~ZBXNEXT-1689~~ to return the values for the lastvalue and lastclock properties item.get needs to perform a separate request to the history table. That means that unnecessary use of output extend may significantly impact performance.

The following places in the frontend must be corrected to not use output extend for item.get:

history.php
popup_trexpr.php
configuration.screen.constructor.edit.php

CApplication::massAdd()
CDiscoveryRule::copyGraphPrototypes()
CGraph::validateItems()
CGraphPrototype::validateCreate()
CGraphPrototype::validateUpdate()
CItem::delete()

CScreenClock::get()
CScreenHistory::__construct()

We should also check if there are other places with this problem.

Comments

Comment by richlv [ 2013 Oct 19 ]

sounds like this would make things very slow in large setups - should this be a blocker ?

Comment by Ivo Kurzemnieks [ 2013 Oct 22 ]

RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-7170