AnsweredAssumed Answered

What is Better Way To Pull The Data From PI To Another DB On Daily Basis And With Faster Performance.. 

Question asked by limesh on May 4, 2016
Latest reply on May 6, 2016 by André Åsheim

Hi Friends,


We have a portal for analyse the data and also reporting purpose, so we are facing an issue while fetching the data from PI to another DB using 'PI SQL DAS' and its getting crashed because of bulk data.

At present we are pulling for 5000 PI snapshot tag data to MySQL  every 10 min interval. Here we are getting problem like crashing 'PI SQL DAS' and also very slow performance.

We want to see 10 min difference live data in portal.

Can any one please help me here, Is any other faster way pulling data from PI to another Data Base on daily basis and with fast performance.