[ZBX-5514] More simple query for get_min_itemclock_by_itemid function Created: 2012 Aug 30 Updated: 2017 May 30 Resolved: 2012 Sep 05 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Frontend (F) |
Affects Version/s: | 1.8.16rc1, 2.0.3rc1, 2.1.0 |
Fix Version/s: | 1.8.16rc1, 2.0.3rc1, 2.1.0 |
Type: | Incident report | Priority: | Minor |
Reporter: | Alexey Pustovalov | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | performance, sql, trivial | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
Description |
In last sql query we use select for multiple itemids and then we calculate min clock for specified itemids. For example: $res = DBselect(
|
Comments |
Comment by Eduards Samersovs (Inactive) [ 2012 Sep 04 ] |
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-5514 |
Comment by richlv [ 2012 Sep 04 ] |
i assume this will improve performance somewhere ? which user visible pages exactly would benefit from this ? <Eduard> Screens, Host screens, Graphs pages now must work a little bit faster.. |
Comment by Eduards Samersovs (Inactive) [ 2012 Sep 04 ] |
Fixed in versions pre-2.1.0 (beta) r30090, pre-2.0.3 r30089 |
Comment by Alexey Pustovalov [ 2012 Sep 04 ] |
Please make this changes in 1.8 too. <Eduard> FIXED |
Comment by Eduards Samersovs (Inactive) [ 2012 Sep 05 ] |
Fixed also in pre-1.8.16rc1 r30102 |