IOMHouston

Performance of retrieving values vis PI SDK APIs versus PiOleDB..

Discussion created by IOMHouston on Jun 4, 2011
Latest reply on Jun 10, 2011 by spilon

I was wondering if anyone could provide some feedback on the performance of using PISDK versus OleDB implementation for PI.

 

I read somewhere that OleDB is based os the PISDK, so one would think that using the PiSDK to values (RecordedValues, RecordedValuesByCount, Summary etc) should be faster than using oleDB when dealing with large volumns of data.

 

However, our findings are just the opposite. In fact, it seemst that using the PISDk is significantly slower.
Internally, the OleDB is taking advantage of some optimizations or API's in the PISDK.

 

Thoughts?
Suggestions for optimization?

 

Thanks

Outcomes