This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.
Our production server has 309 entries in the deferred_bindings table. Some of them date back to March 2015 - but 2 of them, for example, are from about 10 hours ago. I have 2 questions:
- Why do these entries exist? Shouldn't they be cleaned up automatically?
- Can I delete older entries / truncate the table or will that lead to data loss?
(The reason why I want to clear the table is that these records seem to be causing very slow queries for the fileupload field.)
Thanks for any suggestions!
October automatically destroys deferred bindings that are older than 5 days. It happens when a back-end user logs into the system.
Destroys all bindings that have not been committed and are older than 1 day:
October\Rain\Database\Models\DeferredBinding::cleanUp(1);
From: https://octobercms.com/docs/database/relations#cleanup-bindings
1-3 of 3