[ZBX-12416] Optimize query when selecting data from profiles table Created: 2017 Jul 25 Updated: 2018 Oct 09 Resolved: 2017 Sep 14 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Frontend (F) |
Affects Version/s: | 3.0.10, 3.2.7 |
Fix Version/s: | 3.0.11rc1, 3.2.8rc1, 3.4.2rc1, 4.0.0alpha1, 4.0 (plan) |
Type: | Problem report | Priority: | Minor |
Reporter: | Ingus Vilnis | Assignee: | Gregory Chalenko |
Resolution: | Fixed | Votes: | 0 |
Labels: | profiles | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
||||
Team: | Team A | ||||
Sprint: | Sprint 13, Sprint 14, Sprint 15, Sprint 16 | ||||
Story Points: | 0.5 |
Description |
Zabbix web interface performs not optimal query when selecting all data from profiles table. SELECT p. * FROM profiles p WHERE p.userid = ? ORDER BY p.userid , p.profileid Suggested to select only specific columns of the table instead of all * if they are not needed. |
Comments |
Comment by Gregory Chalenko [ 2017 Aug 16 ] |
(1) [F] Translation strings changes. oleg.egorov CLOSED |
Comment by Gregory Chalenko [ 2017 Aug 16 ] |
Fixed in:
|
Comment by Gregory Chalenko [ 2017 Sep 04 ] |
Fixed in:
|
Comment by Gregory Chalenko [ 2017 Sep 14 ] |
Fixes implemented in:
|