Forms 4.6 performance enhancement

After using DotTrace and Jmeter to analyze Forms performance issues, we found some problematic code segments, which created issues like slow response time or high CPU usage. Therefore, we internally changed the Forms API in order to reduce data processing time.

From version 4.6.0, Forms with DDS as the default data storage mechanism has much better performance compared to the previous versions, especially for forms with a large number of submissions. Below is a performance comparison of Forms 4.6.0 and 4.5.1. Our comparison uses Jmeter with more than 20,000 records (all tests are run on the developer's computer).

Forms 4.6.0 takes about 30 seconds to finish the test.

Forms 4.5.1 takes more than 3 hours to finish that test.

We ran another test, and the results looks quite promising when comparing MongoDB to DDS as the data storage mechanism.