Infopath/Sharepoint Performance issue

PHFrench
PHFrench used Ask the Experts™
on
Hello. I had setup a simple Infopath 2010 web browser form that retrieves data from SQL database. It has 2 fields to search data by and displays results in the table, no workflow setup on the form. Connection is converted to ucdx file, that is uploaded to Sharepoint; form (full trust) is also uploaded to Sharepoint as Content Type. It works perfectly fast in Infopath; no records are loaded on opening of the form and once search is performed - it returns anywhere from 1 to 250 records. There are almost 20K records in the SQL table. In Sharepoint I used Infopath web part to load this Infopath form. It works really inconsistent in Sharepoint - initial search could take anywhere from 2 to 20 seconds, but all subsequent searches take 1-3 seconds. Only 2 search fields have setting of postback, only when necessary, table with results is read only and postback set to 'never' for all those fields. I had read all articles I could find about best practices and couldn't find any stable resolution. As I mentioned - sometimes it could take 2 second to pull up the results and sometimes up to 20 seconds. It doesn't matter if initial search returns 1 record or 200 - same delay. We had checked Sharepoint server - no errors or performance issues are recorded. Also experimented with changing SQL query to have only few records, to see if 20K records is a problem, but performance was the same - 1 to 20 seconds for initial search and 1-3 seconds for next search. Please advise!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kyle AbrahamsSenior .Net Developer

Commented:
We had headed down that path originally.  The developers eventually abandoned infopath and put a web part viewer to host a coded ASPX page . . . results were much faster and predictable.

Author

Commented:
So you designed the aspx web page in ASP.NET instead? Any good links that you can point me to? I have experience in designing windows applications in VB, but not web pages in ASP.net. Thank you!
Kyle AbrahamsSenior .Net Developer

Commented:
http://www.asp.net/web-forms

A lot of the skills will translate over.  It's almost exactly the same, and you can code ASP .net in  VB.

The third link down in the main section, "Creating a Basic Web Forms page" Will give you the basics.

In general we abandoned the infopath forms (based on the performance) and used sharepoint as a wrapper for the ASP .Net application.

Author

Commented:
Thank you! Can you explain what do you mean by "used sharepoint as a wrapper for the ASP .Net application"? How do you do that? Any references that I can lookup? Did you have to create a web part? I appreciate your help!
Senior .Net Developer
Commented:
http://office.microsoft.com/en-us/sharepoint-server-help/page-viewer-web-part-HA010024045.aspx

We used the page viewer to navigate to the hosted page.  

So the application "was in sharepoint" but not really, as you could navigate to the URL and hit the internal form . . . but it didn't have the rich UI.  (In fact, all the developers did was code the portion body . . . no need for headers, navigation, etc.) as that was all handled by sharepoint.

Author

Commented:
Thank you! Will review all suggested links.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial