Symptoms

Testing Smartforms on production environment, taking long time to load
 

Diagnoses

When running the IE Developer Tools, each ajaxcall.ashx takes 15+ seconds to run.
We used the Package and Deploy tool to copy the SmartForms and Workflow processes to production.
Noticed SQL Traces that there were thousands of calls to the lFieldOnDemand Stored Procedure on existing processes.

Filtering the profile to the specified process instance for the Smartforms task suggested that at one time, it was taking 8sec from the first call to the last.
When looking at the definition they noticed that there we some absolute datafilds and that the others were set to ?Data on Demand?

 

Resolution

Unchecking Data on Demand those and redeploying the workflow has had a noticeable improvement on performance.
he changed reduced a users task worklist retrieval time from about 20 seconds to below 1 second.