henderson

Workaround for very slow connections

Discussion created by henderson on Dec 1, 2014
Latest reply on Dec 2, 2014 by Gregor

Hello you all. Hope I'm posting this at the right forum.

 

I have a Excel sheet used daily and it has something around 60 PI TAGs which I have to load every day.
The problem is that the user is on an oil rig so the internet connection is really, really, really slow.
If I use the usual "PIarcval" from PI Data Link, Excel sheet takes 10 minutes up to 1 hour to load completely.

 

I am trying to find a way to decrease this time.
I found a crazy technique here: http://www.excelhero.com/blog/2010/05/a-real-time-advanced-excel-chart.html
And I could make it work. The time went from 10 minutes to 10 seconds. This tell me that the internet connection problem is the time response and not bandwith.

 

But this is not a good solution. It's some crazy implemention I did in this sheet.
Is there a way to deal with this is slow connections using just PI DataLink or something like this?
I think that if I could do a bulk request, and request all PI TAGs at the same time, I would have a nice time response.

 

Hope I made myself clear.
I am not a native english speaker, so I sorry for my mistakes while writing.

Outcomes