Ad Widget

Collapse

How to get last item's value efficiently

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • db100
    Member
    • Feb 2023
    • 61

    #1

    How to get last item's value efficiently

    Looking at the history.get documentation it seems the the only way to get the last item's value is by calling SORT and the LIMIT first.

    This looks quite CPU intensive to me if history is quite large. Is there a better way to achieve this ?
    And how does the current php implementation of zabbix achieve this ?

    NOTE: i am looking for a general solution, meaning that it should hold for all history kinds, meaning that i cannot know in advance if the last value is within the last 24 hours or last 2 years for example (this makes using from/to not possible)

    cheers,
Working...