SmartList Run Faster

Posted on May 30, 2012

When you run open a smartlist by default it retrieves the first 1,000 records out of the database.  This can take some time in busy sites with lots of data.  There are two options on handling this issue – 1.  Change the default to a smaller number – this can be done by the System Administration by changing the record count under the Smartlist Options setup and 2. Recreate the smartlist only using the main tables in SmartList Builder. By applying one of these options it can cut down the runtime the smartlists.

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','// ','ga'); ga('create', 'UA-59821054-1', 'auto'); ga('send', 'pageview');