AnsweredAssumed Answered

Nintex form load slow / SharePoint default form fast

Question asked by fabrexav on Sep 17, 2018
Latest reply on Sep 20, 2018 by shrinivasnaik

Hi, 

 

I have a list with 50 fields (including 20 lookup). We made a Nintex form for it, this Form works like a charm on our development environnement and takes 60 to 80 seconds to load on our customer environment. I tried to remove the Nintex Form and with the SP default form it takes 1-2 secs to load ... I'm wondering how it could be so different.

 

We also have other forms for smaller list (10-15 fields, 8 lookups) and we don't have any problem with them (1-2 seconds to load). 

 

We have this log on ULS (just summary not the entire stack trace): 

 

Performance degradation: unfetched field [FIELDNAME] caused extra roundtrip.

---

A large block of literal text was sent to sql (length 53842). This can result in blocking in sql and excessive memory use on the front end. Verify that no binary parameters are being passed as literals, and consider breaking up batches into smaller components. If this request is for a SharePoint list or list item, you may be able to resolve this by reducing the number of fields. Call stack:
at Microsoft.SharePoint.Utilities.SqlSession.OnPostExecuteCommand(SqlCommand command, SqlQueryData monitoringData)

---

Slow Query StackTrace-Managed:
at Microsoft.SharePoint.Utilities.SqlSession.OnPostExecuteCommand(SqlCommand command, SqlQueryData monitoringData)

 

I spent the last 2 days on it, i tried to restart the server without sucess, release as much RAM or CPU just to be sure that there is no problem with our server without sucess, remove some columns on the list and it seems to be better but i have to remove 2/3 of my fields which is not possible.

 

What is really strange it's that the preview of this form is super fast !! and this preview loads the exact same things ! 

 

So i guess it might be a database or security issue but i'm in the dark ...

 

If someone has any idea that would be very nice

 

Thx !

 

Xavier.

Outcomes