 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / February 2006Very Sow Performance
I have noticed some VERY slow performance...nearly unacceptably so...when dealing with a DDLB that gets its data from a secondary data source...in this case it is a SQL Server view of a Customer master table...just bringing back ~12 columns of data...if I use Access to link a table to the view (vwCustomerInfo_basic) it is very fast...when I use IP to select a CustomerName on the DDLB...it takes 4-7 seconds for IP to return to the DDLB field from which it originated...now-if I restrict the SQL view to include only 100 records...the IP DDLB performance is very fast...the entire table only contains ~9000 records...What is going on here? This performance is pitiful. I was able to reduce the size of the Returned Data Set from the view and performance is acceptable now...but WATCH OUT....large data sets will cripple a DDLB! > I have noticed some VERY slow performance...nearly unacceptably so...when > dealing with a DDLB that gets its data from a secondary data source...in this [quoted text clipped - 6 lines] > only contains ~9000 records...What is going on here? This performance is > pitiful. Also, have a look at the following article: http://msdn.microsoft.com/office/understanding/infopath/default.aspx?pull=/libra ry/en-us/odc_ip2003 _ta/html/officeinfopathtroubleshootperformancebestpracticeguidelines.asp Best Regards, Sheetal D, MCSD.NET Microsoft Developer Support This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- Thread-Topic: Very Sow Performance thread-index: AcY72Lvlk+yPI6DhTGuOTK7aOexWhQ== X-WBNR-Posting-Host: 65.242.108.146 From: "=?Utf-8?B?QkZTbWl0aA==?=" <BFSmith@discussions.microsoft.com> References: <7A7EC538-6031-47F4-B299-69D9F73141CB@microsoft.com> Subject: RE: Very Sow Performance Date: Mon, 27 Feb 2006 12:02:27 -0800 Lines: 18 Message-ID: <B4AABC96-436C-4634-8AD7-11779629B956@microsoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Newsgroups: microsoft.public.infopath NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.infopath:27243 X-Tomcat-NG: microsoft.public.infopath I was able to reduce the size of the Returned Data Set from the view and performance is acceptable now...but WATCH OUT....large data sets will cripple a DDLB! > I have noticed some VERY slow performance...nearly unacceptably so...when > dealing with a DDLB that gets its data from a secondary data source...in this [quoted text clipped - 6 lines] > only contains ~9000 records...What is going on here? This performance is > pitiful. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.