There is a good practice to run this code for an external list with 30.000 items?
“query”:”<Where><Eq><FieldRef Name=’AddressID’ /><Value Type=’Text’>447</Value></Eq></Where>”,
“primaryKey”:”AddressID” // this must name the column that holds the primary key in the external list
I have to wait 22 seconds to return 8 values from fields
The problem with querying large lists is that it will run multiple queries in batches of 5000 items – in your case 6 queries. If you bring up the developer console and look at the network tab when you load you should see 6 individual queries.
Do you also see a red line with status 500? – if so, this confirms that SharePoint enforces the list throttling limit of 5000 items for external list as well.
I’m not sure there is a good solution to this issue, but maybe some of the forum users can share some additional insight?
I have successfully used DFFS Cascading Dropdowns with a 47,000 item list. The rendering is MUCH faster using Firefox (15 sec) vs Internet Explorer (3 minutes). A CAML filter in the Optional filter field allows me to pre-filter the list based on an attribute before it shows up in the list dropdown.