We've converting all of our forms from paper to electronic on an enterprise level but we're experiencing some performance issues with our survey regarding the number of questions and choices. We have 1 survey with 1 point and 27 nested related tables. The more fields and choices we add the slower it takes to open the survey and potentially crash. What's our best option moving forward? We still have a few forms we need to add.
IOS - 25 - 30 seconds to open | Version 3.3.40
Windows 10 - 1+ min to open | Version 3.3.158
1 Point FC
19 tables relating back to the Point FC
8 tables relating back to the various tables
926 Fields
Choices: 766
points = ["NEOForms"]
tables = ["ServiceRequest",
"ServiceReport",
"MaterialMovement",
"MaterialMovementItems",
"DIMP",
"AbandonReplacementReport",
"LeakSurveyLinePatrol",
"LeakSurveyLinePatrolLocation",
"PipelineInspection",
"GasLeakandRepair",
"LeakEvaluation",
"OdorComplaint",
"ServiceLineOrder",
"OUPSCallinRequest",
"MAOPCalculation",
"MAOPCalcPipeUsed",
"MAOPCalcOtherAppurtenances",
"InlineValveDescription",
"TestReport",
"TestReportServicesTested",
"PressureProblem",
"RemedialActionReport",
"RemedialActionCP",
"RemedialActionRectifier",
"RemedialActionKeyValve",
"RemedialActionOther",
"AtmosphericCorrosionReport"]