[ODK2] too many sql variables with ODK survey

Support
1

Hi

For a big form, I have a “too many sql variables” error with ODK survey. Is there a limit somewhere ?

20181009_152946
20181009_1529462918×2189 2.25 MB

Thanks

Karim

2

Hi,

The limit is 999 variables but the number of fields you could have will be much lower than that. Some fields take up more than 1 variable, for example geopoint takes up 4 variables and attachments take up 2 variables. We also need to pass metadata variables, which takes up about 10 variables.

I would recommend you to stay much lower than the limit, your survey will perform much better. You could try breaking things up into multiple screens.