AnsweredAssumed Answered

How to query a lot of summaries at externally defined start and end times from a single tag

Question asked by dpfahler on Sep 27, 2019
Latest reply on Sep 27, 2019 by dpfahler

Dear Community,

This question is realted to this:

How to query a lot of intervals at externally defined timestamps in a regular raster from a single tag 

 

Here's my problem:


I have PITags that change about every second.
External quality criteria should now be calculated for individual PITags at certain time points.
The quality criteria include aggregates (=summaries, e.g.: Average, Min, Max, ...) at externally defined intervals (for example: intervals 01.01.2010 10:00 - 01.01.2010 10:05, 01.01.2010 10:30 - 01.01.2010 10:35, ...).

I access the data with the PI Web API and can simply query ONE summary from a PITag:
The endpoint for this is for example:
GET streams/{webId}/summary


However, for a single PITag I have to query tens of thousands of such intervals.
The performance for ten thousand requests is unfortunately too slow and I think there should be a better solution.
What would you have in mind?

 

Thank you very much for your help

Outcomes