Kent Smith asked 4 months 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.
Victor Font Staff answered 4 months 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.
Please login or Register to submit your answer
