Slow loading forms

[Dave Baldwin]

I have a few lists linked together using the forms designer related items and each of the lists has more than 20,000 items. Users are telling me that it takes more than a minute (sometimes two) for the forms to display or submit.

Any ideas about what I can check or modify to speed things up?

Any help is much appreciated.

Dave

[Dmitry Kozlov]

Hi Dave,

Have you tried to create indices for lookup columns in the list settings?

[Dave Baldwin]

It does look like I missed one of them.

I added it and will monitor to see if it has improved.

Thanks for the pointer.

Dave

[SpongeBen SquareJaw]

My form loads fine but my edit form submit take almost 30 second to complete. New form is fast. What could be causing this slow down. I have a million items in list.

[Dmitry Kozlov]

Hello,

You could try to remove fields one by one from your edit form and test its speed. Probably you have a lookup to another list with lots of items that causes the issue.