AnsweredAssumed Answered

Best way to summarise 70,000 tags?

Question asked by AlistairFrith on May 12, 2015
Latest reply on May 14, 2015 by AlistairFrith

We have a need to perform a simple calculation summarising a value over around 70k digital tags. Essentially, we need to keep track the total of a number associated with each tag that is currently Offline. We are not allowed to use AF or ACE. We are thinking of storing the number in UserInt1

 

What is the most efficient way...

 

A windows service, waking up every few minutes and finding all the Offline tags and adding up the associated values?

or

A windows service registering event pipes that adjust the total every time a tag changes to/from Offline?

or

something else?

 

Thanks for any suggestions

 

--- Alistair.

Outcomes