After upgrading 3.0.3 to zabbix server load Oracle database 10g has decreased in 3-4
Performance improvement associate primarily with parameterized insert queries:
insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (:1,:2,:3,:4,:5,:6)
insert into history_uint (itemid,clock,ns,value) values (:1,:2,:3,:4)
It would be nice to parameterize and requests to delete data
delete from trends_uint where itemid=30513 and clock<1434530509
delete from history_uint where itemid=67214 and clock<1465461709
insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (:1,:2,:3,:4,:5,:6)
insert into history_uint (itemid,clock,ns,value) values (:1,:2,:3,:4)
It would be nice to parameterize and requests to delete data
delete from trends_uint where itemid=30513 and clock<1434530509
delete from history_uint where itemid=67214 and clock<1465461709