webformnavigation_log becomes very large with no way to reduce its size

Created on 16 January 2024, 11 months ago
Updated 20 August 2024, 4 months ago

Problem/Motivation

Not sure if this is bug or feature request.

With many forms using this module's navigation feature and more than 200 users filling out forms, my webformnavigation_log table in the database is quite large, using up 1/3 of the total space of my DB. Only the actual webform_submission_data table is larger.

Could there be steps to reduce the size of the DB or expire data after a certain period of time? For example, there are still entries from 2020 in the webformnavigation_log table.

Proposed resolution

A setting that allows the table to be cleaned out after a user-configured duration has passed, if this is safe to do.

✨ Feature request
Status

Active

Version

2.0

Component

Code

Created by

πŸ‡¨πŸ‡¦Canada endless_wander

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @endless_wander
  • πŸ‡ΊπŸ‡ΈUnited States rymcveigh

    I think this could be like the webform draft purge configuration, where the admin defines a set number of days to purge drafts or completed webforms from the system. It does this when cron is run on the system. Would that make sense, or do you have other thoughts?

    The byproduct of doing this will be that if a user visits a form whose logs have been removed, they will not see the pages that have errors or pages they have seen in the past in the navigation bar.

  • πŸ‡ΊπŸ‡ΈUnited States rymcveigh

    Another thought: what if we delete a submission's logs once the submission has been completed?

Production build 0.71.5 2024