Performance Problem with lookup control in large list

[armin o]

Hi there,

the "new" form includes a lookup control to a large list with about 35.000 items.
Pulling all entries from the large list in order to populate the drop down takes too much time (about 5 seconds).
We don't even need the drop-down, because the ID is set via fd.getSourceID() and must not be changed.

Q: How do we handle this?

Thanks,
Armin

[Nikita Kurguzov]

Hello, Armin!
The only thing that I can recommend in this case is to use our Cross-site Lookup instead. It doesn't load all items in bulk, but instead loads them as necessary.

Sadly, you won't be able to search or filter more than 5.000 items list, but there are workarounds for that too - https://spform.com/cross-site-lookup/cr ... 5000-items

[armin o]

thanks!