Forms Designer Forum

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

Hi Dave,

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

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

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.

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.