Currently the reporting solution used in our company is very slow the reason being is slowness in fetching the PI data. The reason behind that is a lot fo PI tags are being used in the report and data is being extracted for each tag using oledb.
Inorder to fix those issues we thought of implementing a PI Data access layer dll which is using oledb to get PI data. We have written various custom functions in this dll which can read/write PI data.Now the problem is the funciton which is acessing PI Archive/Interpolated data can only do PI data call for each tag in a single query or SDK API. We can't pass multiple tags to SDK API's to get PI data so we thought of using Threading . I am trying to use threading but it seems to be me a difficult task....
What is the best way to pull archive data for around 8 tags in one shot ?
What are the best practices used in the industry to pull archive data for multiple tags.