• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 Mango 5 Documentation Website

    Purge Data Frequency

    Mango Automation general Discussion
    3
    4
    1.7k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • H
      henryblu
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • JoelHaggarJ
        JoelHaggar
        last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • phildunlapP
          phildunlap
          last edited by phildunlap

          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.

          1 Reply Last reply Reply Quote 0
          • H
            henryblu
            last edited by

            Excellent, thanks guys - perfect fix.

            1 Reply Last reply Reply Quote 0
            • First post
              Last post