عرض مشاركة واحدة
قديم 19-Sep-2011, 09:08 AM   #1
Monzer Osama
مدير عام منتديات جريت بلينز العربية
افتراضي 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
__________________
Monzer Osama
Saudia Arabia - Jeddah
00966501826235
Microsoft Certified Business Management Solutions Professional
Microsoft Certified Trainer

آخر تعديل بواسطة Monzer Osama ، 13-Nov-2008 الساعة 11:40 AM.
Monzer Osama غير متواجد حالياً   رد مع اقتباس