I have a project which need insert 5000 datapoint into InFluxDB 1.8.1 per second .
How can I do to make it happen?
How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
- BenjaminSeeker
- Posts:30
- Joined: Wed Jan 12, 2011 9:51 am
How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
- kilianvp
- Posts:443
- Joined: Fri Jan 16, 2015 10:29 am
Re: How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
3.16 has no InFluxDB (NGA)
- gschijndel
- Posts:376
- Joined: Tue Jan 15, 2019 3:12 pm
Re: How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
I have no idea how many values CtrlADO is able to insert each second. But I would try the 'dbBulkCommand'.
- BenjaminSeeker
- Posts:30
- Joined: Wed Jan 12, 2011 9:51 am
Re: How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
If there is another way？ like Http API？
- adaneau
- Posts:310
- Joined: Tue Feb 21, 2012 9:49 am
Re: How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
Hi,
That's eventually doable. Strongly advised to write them as bulk, eventually not even every s but as 10s bulks.
Have a look at : https://docs.influxdata.com/influxdb/v1 ... rite_data/
This is the REST interface of InfluxDB. Then you can use the WinCC OA function NetPost to post the data.
Cheers
Alexandre
That's eventually doable. Strongly advised to write them as bulk, eventually not even every s but as 10s bulks.
Have a look at : https://docs.influxdata.com/influxdb/v1 ... rite_data/
This is the REST interface of InfluxDB. Then you can use the WinCC OA function NetPost to post the data.
Cheers
Alexandre
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
Do you want to use the InfluxDB as standard database for historical values in WinCC OA?
If you want to do it that way you can use 3.17 and NGA.
Do you want to write 5000 values every second to the database?
How long will you keep data which is written every second?
What is the load in your project (value changes / second) if 5000 are saved in history?
Normally the load is higher as not every value is saved in the history.
Best Regards
Leopold Knipp
Senior Support Speciaist
If you want to do it that way you can use 3.17 and NGA.
Do you want to write 5000 values every second to the database?
How long will you keep data which is written every second?
What is the load in your project (value changes / second) if 5000 are saved in history?
Normally the load is higher as not every value is saved in the history.
Best Regards
Leopold Knipp
Senior Support Speciaist
- BenjaminSeeker
- Posts:30
- Joined: Wed Jan 12, 2011 9:51 am
Re: How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
Thanks, it help a lot. I will try and test.
- BenjaminSeeker
- Posts:30
- Joined: Wed Jan 12, 2011 9:51 am
Re: How to insert data into InfluxDB with WinCC OA 3.16 P022 windows version
We do not use those data in WinCC OA.leoknipp wrote: ↑ Mon Aug 10, 2020 10:40 am Do you want to use the InfluxDB as standard database for historical values in WinCC OA?
If you want to do it that way you can use 3.17 and NGA.
Do you want to write 5000 values every second to the database?
How long will you keep data which is written every second?
What is the load in your project (value changes / second) if 5000 are saved in history?
Normally the load is higher as not every value is saved in the history.
Best Regards
Leopold Knipp
Senior Support Speciaist
The data stoge in InfluxDB for other system to access with Python.
The data analyst asked for such high frequency.
We need keep those data in InfluxDB for 4 months.
Actually, our data is not changed fastly cause this is a project for district heating.
Maybe I can only store data when value changed.
Then the data storage will reach a lower level like 1000 datapoint per second.