Avoiding common causes of performance issues in Intelligent Forms

Do not use Auto-complete

When you use auto-complete, SmartIQ queries the database to get all of the records and then filters the data using JavaScript. This processing puts a very heavy load on the server depending on what data object you are using. For example, if there are hundreds of thousands of projects in your database and you put a data source on the Project table using auto-complete then the Intelligent Form will never render.

Instead, you could create a custom stored procedure to perform the search and pass in the search criteria entered by the user. Note that every time the user enters a character, the stored procedure will be called, so it is imperative that you limit the number of records the stored procedure can return.

Too many data sources

Limit the number of data sources that are in an Intelligent Forms form. For example, if the form needs to get the values for 20 custom fields from the database, do not create 20 data sources to get them.

Instead create a SQL view that returns all the data

Too many records in a repeating section

For CSV import put a limit of the number of records a user can import. For repeating sections, put a limit of the number of records a user can add.

Setting a condition on Visible

When you set a condition on Visible, all the data sources under the object are loaded. Instead set the condition to Active, which behaves the same from the user's perspective, but the data sources will not be loaded until the condition is met.