EXTERNAL LIST

Forums SPJS-Utility EXTERNAL LIST

This topic contains 2 replies, has 3 voices, and was last updated by  Mike 1 month, 3 weeks ago.

  • Author
    Posts
  • #20225

    lzuhuo
    Participant

    Hi Alex again

    There is a good practice to run this code for an external list with 30.000 items?

    spjs.utility.queryItems({
    “listName”:”EXTERNAL_LIST_DISPLAY_NAME”,
    “query”:”<Where><Eq><FieldRef Name=’AddressID’ /><Value Type=’Text’>447</Value></Eq></Where>”,
    “viewFields”:[“AddressID”],
    “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

  • #20240

    Alexander Bautz
    Keymaster

    Hi,
    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?

    Alexander

  • #22917

    Mike
    Participant

    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.

You must be logged in to reply to this topic.