We deployed a form with 5 sections, two of them have repeating groups and we also have several cascade select questions, my choices sheet has around 1500 rows, and my survey sheet has almost 400 rows.
The final section is a summary of some of the answers in the form, and it sums some of those responses.
My coordinators complain about the form being too slow, I’ve read that I can take the sheet choices to another document and upload it to the form to make the response faster, does this work without internet? I have some people in the field and they have problems with the internet connection.
I was giving a training session with the form and I have a good internet connection and it was really slow too, so I don’t think the internet is the problem.
I need to improve the performance of the form, as soon as possible, PLEAASE, What can I do? !! @Kal_Lam @stephanealoo @Xiphware
Would you try out the following to see whether the rows (1500 rows in your choices sheet and almost 400 rows in your survey sheet) or the long complex syntax within your survey form is causing the lag.
Steps:
Download your xlsform from your KoBoToolbox server (and create a backup if required).
Delete the expressions from the relevant column.
Also delete the calculate question types and the expressions used under the calculation column.
Deploy as a different survey project and see if its still lagging.
If and in case, the newly deployed survey project with 1500 rows in your choices sheet and almost 400 rows in your survey sheet is not lagging, then it should be an issue of the expressions used within your survey form. Try making it short and simple. Sometimes keeping them complex also hampers the performance of the form being deployed.
Hello @analucia_espinoza ,
you may also start the testing, Kal_Lam proposed by reducing the long lists of choices to very few choices and see how this changes speed. If this is the problem, you may change to pulldata approach (doesn’t require Internet with KoBoCollect).
For testing only parts of the App you may enclose other parts with a (test) begin_group and end_group and a relevant = FALSE on this group level…
Are you using KoBoCollect OR Enketo? OCHA Server?
Kind regards
@stephanealoo@Kal_Lam i have 3415 questions, i am using the pull data function. Testing on the web is very fast but when i test it on a cleaned tablet, it turns to run slow.
@theo27, the slowness generally depends upon various factors. Among them, the number of questions itself is one. As you have outlined, 3415 questions should also be a high number. The other factors are the expressions and constraints used in the form. These, too, should affect the form processing time.
