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.