Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# Deletion of Expired Rows

When a row expires, it is available for deletion, but it is not deleted immediately. Deletion is a background process that scans the tables for expired rows and then deletes them. Therefore, the application can retrieve rows that have expired but not deleted.

By default, tables are scanned for expired rows once every hour. The frequency of the scan is governed by the `expiration_scan_period` property. This property is specified in seconds. If the default TTL interval for a row is short or if you want the scanner to run more frequently to delete the expired rows, set the `expiration_scan_period` property when creating the table. After scanning the table, all expired rows are identified and deleted. The rows that expire first are deleted first.

Here is an example that uses the tibdg command to Defining a Table with a default TTL of 1 hour and a scan interval of 5 minutes:

    tibdg table create default_ttl=3600 expiration_scan_period=300 t1 key long value string

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.