Microsoft-provided SmartLists generally touch several tables and run by default until they have retrieved the first 1000 records out of the database. This can take some time in busy sites with lots of data and could cause a
server to stall for 30-180 seconds or more. However, you can recreate the SmartList with SmartList Builder using only the primary tables. For example, the typical run time for an SOP sales order transaction SmartList recreated with SmartList Builder was reduced to 3 seconds from 95 seconds.
Also, you can change the default record count on all SmartLists to 100-200. Users typically pull SmartLists as lookups. When they get the default list open, they enter search criteria and try to find certain records. They usually don’t need more than a few records. Those few that want the "run of the database" can change the record count when they enter their search criteria.
No comments:
Post a Comment