Max number of fields in ODK form


I am coming across a form which contains around 3000+ fields of data. Its basically a long grid-like matrix that needs to be filled. While form coding is a separate (and painful?!) issue, I just want to know what is the max limit of fields that can be supported by ODK Central + associated database? I remember MySQL gets a huge hit on performance after a certain number of columns (I think 4096). Just wondering if I can expect some issues in ODK for this?

Many thanks,

There's no hard coded limit. We've seen forms with 8,000 fields working in Central. That said, how well a form that big will work in practice depends on the complexity of the form, the number of submissions, and whether or not you'll have media, and the strength of your infrastructure.

1 Like