Goodtech

Performance risk on the PI system with OleDB interface

Discussion created by Goodtech on Nov 8, 2011
Latest reply on Nov 9, 2011 by Ahmad Fattahi

We are now in the process of developing a .NET application (a service) that will query PI records from piarchive..picomp2 periodically. We use PI OleDB interface towards PI. The service, i.e  OleDb client, is running on a computer different from the PI server. The number of tags that will be queried are approx. 3000. They will be queried for records automatically about every 60 seconds. We are grouping the tags in groups of 10-500 tags and each group of tags are queried in a seperate thread. We use the multithreaded connection string option  "Session ID=-1;"

 

 

 

My question is:

 

Is there any possibility that the OleDB link can cause a performance risk on the PI system during such data retrieval? Or is the PI system protected against heavy load from this kind of interface? Does anyone have a good method for measuring the load on the PI system?

Outcomes