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
<SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>
<SPAN class="comment token"># points</SPAN>
points <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"NEOForms"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># tables</SPAN>
tables <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ServiceRequest"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"ServiceReport"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"MaterialMovement"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"MaterialMovementItems"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to MaterialMovement</SPAN>
<SPAN class="string token">"DIMP"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"AbandonReplacementReport"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"LeakSurveyLinePatrol"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"LeakSurveyLinePatrolLocation"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to LeakSurveyLinePatrol</SPAN>
<SPAN class="string token">"PipelineInspection"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"GasLeakandRepair"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"LeakEvaluation"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"OdorComplaint"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"ServiceLineOrder"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"OUPSCallinRequest"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"MAOPCalculation"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"MAOPCalcPipeUsed"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to MAOPCalculation</SPAN>
<SPAN class="string token">"MAOPCalcOtherAppurtenances"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to MAOPCalculation</SPAN>
<SPAN class="string token">"InlineValveDescription"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"TestReport"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"TestReportServicesTested"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"PressureProblem"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"RemedialActionReport"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"RemedialActionCP"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to RemedialActionCP</SPAN>
<SPAN class="string token">"RemedialActionRectifier"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to RemedialActionCP</SPAN>
<SPAN class="string token">"RemedialActionKeyValve"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to RemedialActionCP</SPAN>
<SPAN class="string token">"RemedialActionOther"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#* Related to RemedialActionCP</SPAN>
<SPAN class="string token">"AtmosphericCorrosionReport"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>