schugh@nalco.com

.Net Threads to access PI Archieve Data for mutliple tags using OLEDB\SDK

Discussion created by schugh@nalco.com on Jun 8, 2011
Latest reply on Jun 10, 2011 by spilon

Hi Alll

 

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.

 

Kindly advise..

 

 

 

Regards

 

Sandeep chugh

Outcomes