Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

  • Hello,

    I have an SQL data source set-up which I would like to poll every 10 seconds. This data is for display purposes only and I would like to discard it after - within the next minute for instance. In setting up all data sources, however, I have noticed the minimum purge duration is one day.
    0_1505098134719_355d5c03-a87c-4be2-9ebc-9d650f3ffccf-image.png
    0_1505098188727_c0185eb0-1d73-41cf-84cd-4771c86ed6bb-image.png

    Is there a custom way to purge data older than a minute?

    Cheers,
    Henry


  • On each Data Point you have a Logging option. Set the Data Points to Do Not Log and the data will not be stored in the first place. Mango only does a purge task once per day. Doing daily purges can add overhead on a larger system so it's better to not log the data in the first place.


  • Yes, what Joel said, and then update the default cache sizes for all the points on the source to keep the quantity of history you'd like to be able to see. Then you'll just keep it all in memory. If you're polling every ten seconds and want a minute of data, then default cache size of six.


  • Excellent, thanks guys - perfect fix.