AnsweredAssumed Answered

Slow processing time when Querying objectIds

Question asked by ryansmith52 on May 28, 2015
Latest reply on May 29, 2015 by btfou

Hi guys. I'm performing a query based on a set number of objectids but the processing time of the query takes really long to complete. It varies between 30seconds - 60seconds. I've tried two approaches, using objectIds in a where clause ("OBJECTID IN (1,2,3....)") and passing an array to the query.objectIds parameter. Can someone please help me understand as to why this takes so process and what can i do to improve this processing time@? The reason i need to search by objectIds is because i'm reading from a feature layer which has more than 1000 records, so i obviously need to perform queries on each batch and then use the results elsewhere.

 

Thanks,

Ryan

Outcomes