AnsweredAssumed Answered

PIPointList.RecordedValues slow performance

Question asked by Jeevan on Dec 15, 2015
Latest reply on Dec 15, 2015 by bshang

Hi,

 

I'm using AFSDK to retrieve values for about 50,000 tags. I'm using the PIPointList.RecordedValues method:

 

     var points = PIPoint.FindPIPoints(server, query);

     var pointList = new PIPointList(points).RecordedValues(new AFTimeRange("-30m", "*"), OSIsoft.AF.Data.AFBoundaryType.Inside, null, false, pagingConfig).ToList();

 

The above query takes about 40 seconds to complete. If I increase the time to retrieve the values for the last 5 hours, it takes 155 seconds to complete.

 

I need to retrieve the values for the past 2 days. If I change the time to '-48h', the query doesn't even complete. In the PI SMT, in the message logs, I can see warnings that say 'throttling rate of incoming events...". This makes me think that the call is not being made in bulk and is instead being made multiple times.

 

Can anyone suggest how the performance of this query could be improved?

Outcomes