Does form results have an entry limit?
We have a large community event which has the potential of gathering over 1,000 messages in our ‘Contact Us’ form on our site. Is there a risk that we will exceed the total amount of entries allowed in ‘Form Results’?
Haven’t experienced any issues so far but looking to plan alternative solutions if needed.
Using version 9.4.7
The example contact form and other Express based forms don’t have a hard limit on the number of submissions. The dashboard pages for showing results may be limited by web server resources, especially if permissions are involved. That depends on your web server and is unlikely to affect your level of use.
Where you need to be careful is the complexity of submissions for Express forms. This wont be a problem with the example contact form, but adding too many extra fields and especially where multiple Express entities are related will escalate the complexity of the Express data involved and the resources involved in writing/reading that data.
For an evaluation of speed, see https://forums.concretecms.org/t/partner-meeting-recap-and-video/3111/3. Access to that thread may be limited. Key posts are by @JeffPaetkau comparing creation and deletion of 1000 express objects.
- Express: 170.6s
- Doctrine: 4.9s
- Doctrine with batch flush: 0.4s
This doesn’t map to your scenario of 1000 contact records one at a time, but does illustrate the general limitations imposed by complexity of how Express works.
For more than the core Express based forms can do, there are advanced forms packages in the marketplace including my own Form Reform.
Really appreciate the detailed response @JohntheFish. You are correct in assuming that this is for general use, other than the text field for questions/comments, we have a name field, email field, and few radio buttons to help filter by topic which sounds in line with minimal complexity.