We have a project with over 45000 uploaded files. Whenever we use the fileupload field in the backend, query times get very long - 5+ seconds are not unusual. Has anybody else experienced this? As it's an in-built component I'm not sure what we can do to optimise. Many thanks in advance for any suggestions!

I think I might have tracked it down - there were 309 entries in the 'deferred_bindings' table. Truncating that table resolved the issue and made the entire backend much much faster. What would lead to the deferred_bindings table filling up? Is it safe to truncate it on a production server?

I'll leave this post in case others have the same problem + have asked about deferred bindings here: https://octobercms.com/forum/post/can-i-truncate-or-delete-old-deferred-bindings

Hey Nils,

Did you every get to understanding why this was happening?

Thanks.

Hi Greg, no but it eventually became a non-issue, clearing the deferred_bindings table made the entire backend much faster for us. May have been connected to it being a test server with lots of non-standard user activity. (as an aside we later wished we'd used pure Laravel instead of octobercms for more flexibility / performance, so if you're just setting out give that some consideration)