AnsweredAssumed Answered

what is the best way to display large set of data in WPF application.

Question asked by mdspath on Dec 14, 2018
Latest reply on Dec 28, 2018 by Rick Davin

Hello,

 

We have a AF SDK based WPF application which retrieves the tag data for a given interval of time. Below is the code.

 

var config = new PIPagingConfiguration(PIPageType.TagCount, 10000);
IEnumerable<IDictionary<AFSummaryTypes, AFValues>> listAvgResults = 
        pointList.Summaries(myTimeRange, span, type, AFCalculationBasis.TimeWeighted, AFTimestampCalculation.Auto, config);
IEnumerable<AFValues> afValues = listAvgResults.Select(pointResults => pointResults[type]);

foreach (AFValues pointValues in afValues)
{
    // constructing the data table here
}

 

for less number of tags and time interval for 1 hour this code works fine. But when the time interval is for 10 sec for 3 weeks and number of tag is 20, this foreach runs take lot of time to execute (min 1 min) .

 

while searching i came across OLE DB where there is access to PI archive for getting data..Since the output from the query is directly in DataTable, should I use this ?

 

And please provide the download link for OLE DB enterprise 2017,

Download links in the below URL are broken

 

PI OLEDB Enterprise - Announcements

 

Thanks

Mike

Outcomes