AnsweredAssumed Answered

Performance Issue with PI SQL Integration

Question asked by Sidh on Jun 25, 2018
Latest reply on Jun 27, 2018 by gregor

Hello Mates,


I have a scenario where an application is using OLEDB to fetch PI data in combination with SSIS to fetch data from PI and storing back in SQL DB, C# is being used to fire SQL queries to PI for data retrieval.


But there are some performance issue which we want to improve basically we want to improve the turn around time connection takes to fetch data.


Any idea of going with some other integration solution or connection methodology like customized interface using AFSDK connection?