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.