SIGN UP

Archiving Entries for a high volume form

By: Kent Smith | Asked: 10/23/2024
Forums › Category: How-to › Archiving Entries for a high volume form
0 Vote Up Vote Down
Kent Smith asked 6 days ago
I have a client site that contains forms which may see up to 1,500 form entries per week. Each entry will have an image uploaded/attached to it. I anticipate over time this will impact performance, if only by the number of images being uploaded with form entries. The client does need the ability to go back and look at past form entries and the associated file uploads in case of an audit need. I think I will need a method to archive form entries and the associated file uploads but am uncertain of the best approach to implement such a solution. I'm looking for any suggestions on how to deal with high volumes of form entries. Thanks in advance for your thoughts.
1 Answers
0 Vote Up Vote Down
Victor Font answered 5 days ago
There is no built-in archiving feature in Formidable. Archiving requires a bespoke solution. I suggest using a Business Intelligence approach to archiving your data where you create an operational data store (ODS) consisting of a normalized schema. As for the images, I'm not sure what to do with those, they need to live on the server if you want to display them in a view.
Kent Smith replied 5 days ago

Thanks for your thoughts on this topic.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right