I have a requirement to retrieve around 15,000 values via web service call and display them on Nintex form as option values in a drop down list.
This drop down list needs to sit in a repeating section control so it needs to show on each new row as well.
Options I thought of are below but I was wondering what would be the best one or if you have a better suggestion.
1. Store them in a SharePoint list and use list lookup on the form, however, there is SharePoint limitation of 5,000 records that can be retrieved.
2. Store them in a SQL database and lookup from from. Possible performance issue on retrieval? any limitations? I measured the total size of 15,000 records in string format and it is around 300kb.
3. custom jquery that calls a web service using the first 1-3 letters typed in and display filtered options? This option is preferred one but not sure if it will work in a repeating section control?