EXTERNAL LIST

Forums SPJS-Utility EXTERNAL LIST

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 6 months, 1 week 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

You must be logged in to reply to this topic.