منتديات جريت بلينز العربية Great Plains For Arab

منتديات جريت بلينز العربية Great Plains For Arab (http://www.gp4arab.com/forum/index.php)
-   English GP Forum (http://www.gp4arab.com/forum/forumdisplay.php?f=4)
-   -   Making SmartLists Run Faster (http://www.gp4arab.com/forum/showthread.php?t=317)

Monzer Osama 19-Sep-2011 09:08 AM

Making SmartLists Run Faster
 
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

عماد زيد 19-Sep-2011 09:18 AM

Thanks for the tips.

ahai 19-Sep-2011 10:19 AM

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

download2m 27-Nov-2011 09:09 AM

thanks man


جميع الأوقات بتوقيت GMT +3. الساعة الآن 06:11 PM.

Powered by vBulletin® Version 3.8.3

الموقع والمنتدى من تطوير » شركة المنذر للاستضافة والتصميم


الموقع لا يمثل أي جهة رسمية بل هو جهد شخصي يرمي الى تجميع القدرات في برنامج جريت بلينز