AnsweredAssumed Answered

What is a Practical Volume Limit for Query List?

Question asked by steven.amico@kodakalaris.com on Mar 23, 2016
Latest reply on Apr 13, 2016 by steven.amico@kodakalaris.com

Can someone please advise on the practical limit of the number of items that a Query List action can process before timing out?  My understanding is that Query List does not take advantage of Indexed Columns.

 

Reference:
This is a product improvement request that was created in July 2014.
https://nintex.uservoice.com/forums/229405-1-nintex-workflow-for-sharepoint/suggestions/6231594-query-list-action-doesn-t-scale-to-support-indexed

 

I will be creating a document library that will have several thousand documents added to it each month.  I will need to periodically (daily / weekly) check some fields with a workflow to determine action to be taken on the appropriate documents.  Any field I use in a Query List action will be indexed.  I have read that the Query List action will time out with large lists, and also that it could encounter the 5,000 item list view threshold.  If it has to look at each item in the list to determine if the criteria are appropriate to include it in the resulting collection, it seems that this would fail at 5,000 items.

 

Can anyone confirm how Query List selects items (sequential read or indexed read) and at what volume of items it becomes impractical to use?  Thanks!

Outcomes