Skip to Main Content
InterSystems Ideas

Have an idea, suggestion, or something that doesn’t work as expected in InterSystems products or services? Share it here on the InterSystems Ideas Portal.

The Ideas Portal is where community members can propose improvements, report bugs, and help influence the product roadmap across InterSystems products and the overall developer experience. 22% of submitted ideas are implemented by InterSystems or members of the Developer Community.

💡 Ideas and bugs are both welcome, no matter how big or small. You can submit feature requests, usability improvements, workflow suggestions, and bug reports. Whether you’re an experienced expert or just getting started, your fresh perspective is valuable.

🛠️ About bugs and fixes. If you have access to InterSystems WRC, please submit bugs there for immediate action. Bug reports submitted through the Ideas Portal are reviewed and tracked, but do not guarantee immediate resolution.

Start by sharing what could be better - the community and our teams will help take it from there.

Status Community Opportunity
Created by Ashok Kumar T
Created on Jun 24, 2025

TTL(Time To Live) Parameter in %Persistent Class

1️⃣ Description of the idea

Introduce a new TTL (Time-To-Live) parameter within the %Persistent class. When enabled and configured with a time value (in seconds), this parameter automatically adds an internal expiration timestamp property and add timestamp to each record when inserted. The system will then monitor and delete records once the TTL has expired. This mechanism provides an elegant, class-based alternative to managing temporary data traditionally stored in temporary globals.

2️⃣ Who is the target audience?

  • Application developers who handle time-sensitive or transient data and migrating from temporary globals to class-based solution.

  • System architects aiming for cleaner, declarative data lifecycle management.

3️⃣ What problem does it solve?

Eliminates the need for manual deletion logic or external cleanup jobs for temporary data if it's implemented by default.

Offers a standardized, declarative TTL mechanism across the data model.

Simplifies development by making expiration behavior part of the class definition without complexity.

4️⃣ How does this impact the efficiency, stability, reliability, etc., of the product?

Consistency: Encourages a unified and declarative approach to managing temporary data across applications.

Efficiency: Automatically purging expired records reduces memory/storage overhead.

5️⃣ Provide a specific use case or scenario that illustrates how this idea could be used in practice

A web-based scheduling system temporarily stores schedules for 30 minutes. When a user opens the scheduler, a class is defined to manage the session. The system automatically deletes these records after 30 minutes.

  • ADMIN RESPONSE
    Aug 20, 2025

    Thank you for submitting the idea. The status has been changed to "Community Opportunity".

    Stay tuned!

  • Benjamin De Boe
    Aug 20, 2025

    Hi @Guest , this feels like something that would be a natural use case to implement using Table Partitioning and a simple maintenance task. If you haven't already, please join the Early Access Program through https://community.intersystems.com/post/early-access-program-new-table-partitioning-feature