Hello!
It will be great to implement binded variables using in some cases if we use Oracle as database.
The list of SQL's where binded variables should be implemented is:
1 select distinct t.triggerid,t.expression,t.status,t.dep_level,t.pr iority,t.value,t.description from triggers t,functions f,items i where i.status<>3 and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid=18113
2 select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1
3 select num,value_min,value_avg,value_max from trends where itemid=17940 and clock=1171270800
4 update functions set lastvalue='499' where itemid=20043 and function='last' and parameter='0'
5 select distinct function,parameter,itemid,lastvalue from functions where itemid=18700
6 select 0,lastvalue from functions where functionid=11642
7 select distinct t.triggerid,t.expression,t.status,t.dep_level,t.pr iority,t.value,t.description from triggers t,functions f,items i where i.status<>3 and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid=25889
There are some sql's in web-frontend, but their's performance impact is not so great.
Is it possible to implement this in one of the next releases?
It will be great to implement binded variables using in some cases if we use Oracle as database.
The list of SQL's where binded variables should be implemented is:
1 select distinct t.triggerid,t.expression,t.status,t.dep_level,t.pr iority,t.value,t.description from triggers t,functions f,items i where i.status<>3 and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid=18113
2 select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1
3 select num,value_min,value_avg,value_max from trends where itemid=17940 and clock=1171270800
4 update functions set lastvalue='499' where itemid=20043 and function='last' and parameter='0'
5 select distinct function,parameter,itemid,lastvalue from functions where itemid=18700
6 select 0,lastvalue from functions where functionid=11642
7 select distinct t.triggerid,t.expression,t.status,t.dep_level,t.pr iority,t.value,t.description from triggers t,functions f,items i where i.status<>3 and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid=25889
There are some sql's in web-frontend, but their's performance impact is not so great.
Is it possible to implement this in one of the next releases?
Comment