Form initiation is slow

[colinwhunt@gmail.com]

When I click the link for the a list item from its native list view page ("All Items") there is a delay everytime before the SP Form starts to process. It is about a 5 second delay to either the Edit, Display or New Form. I have removed all Lookup fields and just have Option lists.

Have you experienced this type of behaviour when loading the different forms? It is like it is thinking and determining which form to load.

[colinwhunt@gmail.com]

I added two more site columns to the list which have maybe 15 items in the list and the new form now takes 35 seconds to load. The native sharepoint new form takes about 8 seconds. I am not sure what I am doing wrong but this is pretty straight forward expected functionality and having a user to wait more than a few seconds for a simple form to load is unnacceptable.

If anyone had any info on how to better manage this please help.

[Dmitry Kozlov]

Hi,

The loading time totally depends on the number of columns on the form, additional controls, and custom JS-code. I can recommend you to split the from into multiple ones with the help of Form sets (for SharePoint On-line) or Groups (for SharePoint on-premises). The default form will contain links to other forms. Use 'fd.openFormInDialog' method to open a form in a dialog:

Code: Select all

fd.openFormInDialog('FormName.aspx');

http://spform.com/documentation/js/manager

[colinwhunt@gmail.com]

Thank you for your reply. Is there more documentation on how to implement this?

Also, i removed all the simple option list controls from the New Form and the form went from loading in 35 seconds to 5 seconds. I removed approx 6 choice fields where 4 of them were Yes/No fields. The others had a max count of 20. There is minimal javascript so the speed issue doesn't make sense to me.

[Dmitry Kozlov]

Hi,

I suppose you're using SharePoint on-premises, am I right? If so, please, read the following post:

http://spform.com/forms-designer- ... rint-forms

Also, make sure that you have enough memory on the server.

[colinwhunt@gmail.com]

Thank you Dimitri. I will take a look at that post.

I have performed some speed tests on duplicate list with a different column type for my lookup column. Here are the results.

List New Form Edit Form View Form SpForms New Form Test - No Lookup 4.93s 4.54s 4.11s 6.23s Test - Advanced Lookup 6.41s 7.74s 6.96s 7.72s Test - Site Column - Choice 6.6s 3.8s 4.4s 7.76s Test - Site Column - Lookup 5.2s 8s 9.8s 16.8s Test - Choice Field 5.1s 5.05s 3.76s 8.25s

For some reason when using a site column that is a lookup column within SP Forms there is a significant delay. I do expect a little bit of delay but not a 10 second delay. I just thougt I would share this with you.

[colinwhunt@gmail.com]

Sorry, I forgot to mention that I need to use a Lookup type column as we have a list of brances within our company and each branch has a Branch Name and a Branch Code which needs to be added to the list.

The test were also based on one custom SP Forms New Form and the rest using defaults. Some other things to note is I am using SharePoint 2016 but I don't think that should make a difference.

[Dmitry Kozlov]

Hi,

I believe that it's something wrong with your SharePoint environment, because in our SP2013 farm a custom form containing lookups opens in 1-2 seconds. Also, we have not received such issues from other customers who use SP on-premises. We will test the case deeply in SP 2016. Anyway, thanks for the report. I will keep you informed on our research.

[Dmitry Kozlov]

Could you save the list as template, export the from in Forms Designer, and send both files to support@spform.com?

[Dmitry Kozlov]

Just tested a simple form with a multi-value lookup in SP2016. The result is 2.07 sec with no cache: