Link to home
Start Free TrialLog in
Avatar of PHFrench
PHFrench

asked on

Infopath/Sharepoint Performance issue

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!
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

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.
Avatar of PHFrench
PHFrench

ASKER

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!
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.
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!
ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you! Will review all suggested links.