Making SmartLists Run Faster

[Monzer Osama]

Alsalam Alykum
From my E-mail:

Microsoft provided SmartLists generally touch several tables and run by default until they have retrieved the first 1000 records out of the db. This can take some time in busy sites with lots of data and I have seen them cause a server to stall for 30-180 seconds or more.

Use SmartList Builder and recreate the SmartLists using only the primary tables. For example, I rebuilt the SOP sales order transaction SL and the run time at one site went from 95 seconds typical to 3.

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 certian records. They usually dont 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

[عماد زيد]

Thanks for the tips.

[ahai]

Really it is an important tip which every SA should notify his team about.

[download2m]

thanks man