Can any one tell me how to query the NoSQL database for a data points latest time stamp?
We are reading data from a MySQL database and I use a flag column to determine if a data point has been read into the Mango NoSQL tables. At the moment I am just triggering the flag to change from a 0 to 1 every 30 seconds. This used to be enough time for Mango to read the MySQL data points with a 0 flag. But as I am adding more data points to the system, the flag is changing to soon and I am missing data points going into Mango. For various reasons, I can't extend the time of the trigger any further.
So now for a change of procedure, I would like to build an update statement in a SQL data point to check if the time stamp of the MySQL data point is greater than the last time stamp in the NoSQL database.
Thank you for your advice