Hi all,
I want to create an interface JSON and SNMP for accessing the latest data values of all items on the server (~ 5100 values). Is there a way of doing this without stressing the server to much via API or the PHP frontend? I was hoping for a latestdata table in DB with one item/row that is updated every time an entry is added to the history table.
Whould having a table like this a bad idea or the gain in speed is insignificant? Maybe this table can be set in memory.
Ragards,
Rares
I want to create an interface JSON and SNMP for accessing the latest data values of all items on the server (~ 5100 values). Is there a way of doing this without stressing the server to much via API or the PHP frontend? I was hoping for a latestdata table in DB with one item/row that is updated every time an entry is added to the history table.
Whould having a table like this a bad idea or the gain in speed is insignificant? Maybe this table can be set in memory.
Ragards,
Rares