I'm looking for suggestions for pulling large amounts of data from PI. I need 4 different PI points from roughly 20,000 elements for a time span of one year. The data for each point needs to be summed to the ordinal hour.
Here is the situation. I have four substations with roughly 5,000 meters each measuring four different values (kWh delivered, kWh received, kVARh delivered, and kVARh received). Depending on the meter, I will have either hourly data or quarter hour (every 15 minutes). I need all data totaled to the ordinal hour for each meter.
I have tried VB script in excel but that is taking a very long time (over 1 day for 5000 meters for one month). I have also tried VB.net, but that is also taking too long (about 1 day for 5000 meters for two months).
FYI...I am using a pointlist in VB.net to make one call for about 2,500 meters with a timespan of one hour.