We have developed a rather large survey.
It contains 1139 questions
(when data is exported to Google Sheet it contains 1597 columns)
The data collector is using a smartphone for collecting the survey data.
They open enketo for collecting data.
The issue for the data collector is that the empty form takes a “long” time to load (1-2 minutes - my last test was 1 minute 31 sec )
In some cases the data collector saves the form as draft. (Which takes only seconds - except the popup telling you the draft is being saved does not dissappear for a long time or the screen freeze for roughly a 1 min 30 sec.)
When they want to open the draft it takes again a very long time (my last test 1 minute 42 seconds).
I am testing this on a low-end small tablet. But the data collectors are saying it can take up to 5 minutes to load a draft.
The first issue is that the data collector think nothing is happening, because when you select to load the saved draft - there is no indication that the draft survey is loading. Please consider showing some kind of hour glass while loading, so it is clear that something is happening.
Is there some hints on how to speed up load time of the saved draft form?
the form contains
- many calculations
- a few (3) user uploaded images (max size is not set !)
- 6 select from file questions (facility list (10.000 units) and administrative units of Nepal) which are stored in 5 different CSV files (See attached for file sizes)
I can try to optimise the survey changing one of each of the above issues, but if some issues are known to create loading problems, I would like to try that first
This is a link to the .xslx file in my Google Drive open for comments 2023-01-28 SPARS Supervision tool - Google Sheets
Any suggestions are most welcome