Steps to reproduce:
I am Lookup for solution fast query API event.get my database now almost 2TB and I am trying to college the report from Zabbix through API by using method below:

{ "jsonrpc": "2.0", "method": "event.get", "params":

{ "output": ["name", "severity","acknowledged"], "groupids": "140", "selectHosts": ["name", "host"], "time_from": "1610530382" }

, "auth": "8a70c2b4b130e72cb7327db4fd41f28c", "id": 1 }

when I try to get problem
more then 7/day it was respond code 500 error which mean there is long timeout execute.

Is there any solution to get more faster query through API?
looking for your respond!

Result:

See log file...
See memory dump...
Expected:
See screenshot....
See attached patch file...