AnsweredAssumed Answered

Want to fetch large chunk of data...should be fast.

Question asked by ilyas Champion on Jul 14, 2015
Latest reply on Jul 14, 2015 by dng

Hello Everyone,

 

We have a PI Server with around 20k tags.

One of our customer built Web App which is Java based and using jdbc data access product to access the data and show it as a trend on it.

 

the user will select one tag and period for a trend.Some tags have 1 sec, 3 sec, 5 sec and 30 sec data.

The data sample  are as follows

  • 1 tag, 1 week 10 min avg data
  • 1 tag, 1 month 10min avg data
  • 1 tag, 6 months 10min avg data
  • 1 tag, 1year 10 min avg data
  • 50 tags, 6 months 10 min, 1day avg avg data
  • 50 tags, 1yesr day avg data

 

We are trying other data fetching possibilities, right now we tried web services based data access.

 

We need some guidance and best solution for above data fetching issue.

The option I see

  • Web API
  • PI AF SDK
  • PI SDK
  • Web Service
  • OLEDB

 

Also if there any other indirect method like developing AF SDk Wrapper as data provider kindly let us know.

 

Thanks

Outcomes