List View - Performance

Symptoms

After creating a SmartObject using a stored procedure in a SQL table, loading the data into a list view is causing a performance lag.

Diagnoses

This is due to the number of data items being searched.

Resolution

Using paging will increase the list load performance. This decreases the number of lines that appear on a page and drop down the number of items loaded at a time.