Skip to main content
13-Aquamarine
January 4, 2023
Solved

When data stored in a value stream is available from thingworx services

  • January 4, 2023
  • 1 reply
  • 981 views

I am getting from kepware a number of 160 changes on property A, 80 changes on property B and 40 changes on property C and D. the values ​​are received in a time interval of 90 seconds. These values ​​are stored in a value stream. Could it happen that a service, executed during the arrival of the data, still doesn't see the data, arrived in the previous instant, inside the value stream?

Best answer by DmitryTsarev

Are you storing your value streams in Postgres or Influx, clustered or not?

 

To put it shortly, in a simplified / degenerate case, I'd say yes, this is true for many / most "AP" NoSQL databases, as well as for relational RDBMS with master-slave replication or sharded RDBMS.

You can read about the CAP theorem and distributed databases, but take care - it's quite a rabbit hole

 

But what's the question actually about? Do you have a particular issue / use case?

 

1 reply

17-Peridot
January 9, 2023

Are you storing your value streams in Postgres or Influx, clustered or not?

 

To put it shortly, in a simplified / degenerate case, I'd say yes, this is true for many / most "AP" NoSQL databases, as well as for relational RDBMS with master-slave replication or sharded RDBMS.

You can read about the CAP theorem and distributed databases, but take care - it's quite a rabbit hole

 

But what's the question actually about? Do you have a particular issue / use case?