[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:
Duplicate
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.
No changes.

oleg.egorov CLOSED

Comment by Gregory Chalenko [ 2017 Aug 16 ]

Fixed in:

  • branches/dev/ZBX-12416 r71335 for 3.0, 3.2
  • branches/dev/ZBX-12416-34 r71332 for trunk
Comment by Gregory Chalenko [ 2017 Sep 04 ]

Fixed in:

  • 3.0.11rc1 r72142
  • 3.2.8rc1 r72145
  • 3.4.2rc1 r72149
  • trunk r72151
Comment by Gregory Chalenko [ 2017 Sep 14 ]

Fixes implemented in:

  • 3.0.11rc1 r72640
  • 3.2.8rc1 r72641
  • 3.4.2rc1 r72642
  • 4.0.0alpha1(trunk) r72643
Generated at Thu Mar 28 20:24:19 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.