Symptoms

We have a large form that is currently taking about 30 seconds to open up. The form does use quite a few dropdown controls pulling from SQL server.
 

Diagnoses

How the form is designed and how the rules are configured will also affect form performance.

Please see the articles below:

https://help.k2.com/kb001432 http://coe.k2.com/smartforms-performance-tuning https://johnnyk2com.wordpress.com/2015/08/12/optimizing-smartforms-performance/ http://www.datalytyx.com/how-to-improve-k2-smartforms-performance/

Resolution

Looking at the fiddler trace, a SmartObject call was determined to be taking a lot of times and will address accordingly.

If applicable, usually using SmartObject input properties to return only the necessary rows will improve performance. Additionally, depending on how the SQL Servers are in this environment and how the SQL server service configured, the following may apply: https://help.k2.com/displaycontent.aspx?id=5998

If these SmartObject calls are independent, perhaps executing them asynchronously or in a batch way via Execution rules will improve overall performance.