When creating a custom form, there is a maximum practical limit of the size of the dataset based on the form created.
The actual size is dependant on the size of the form i.e. how many fields the form has combined with the number of responses which are then stored against that form.
Each form you create will have a number of fields - each time someone fills in that form, a value will be stored against each of those fields and it this result which determines the maximum size.
The maximum total size of form submissions is 150,000 records per form.
If you have a form with more than 150,000 records you will experience significant load times when loading pages and viewing data including running reports on the data - in addition, you may experience time outs when
Example 1 - you have a form with 50 fields and this is filled in 1,000 times - this is 50,000 records hence this is supported.
Example 2 - you have a form with 250 fields and this is filled in 1,000 times - this is 250,000 records hence this is NOT supported.
It does not matter if the field is empty as we still store the empty state.
If you find yourself in this situation, you can create multiple form instances.
For example, your 2022 performance review form has 200,000 records - in this instance, you can simply clone the form and call the new form 2023 performance review and, as this is a new form instance, the counter starts again.
The only "downside" to this is that the data will be separated so cannot be reported on in a single view but each individual form instance can still be downloaded and can still be used in reporting.