Apex Code Development You need to sign in to do that
Don't have an account?
SOQL query time out for Task table
I'm trying to run this query below, but the query times out if the date is further in the past than two days. Could there be a problem with the table not indexing the column lastmodifieddate? Is there an optimal query variant or a way to break up this query into smaller batches? Our task table is very big fyi.
select id from task where lastmodifieddate > 2013-09-20T09:00:00-0700 and lastmodifieddate < 2013-09-20T10:00:00-0700 order by id limit 10
Thank you!
Hi Karate,
See this links below should help,
http://boards.developerforce.com/t5/APIs-and-Integration/REST-API-gt-SOQL-QUERY-TIMEOUT-Issue/td-p/409511
http://salesforce.stackexchange.com/questions/10539/soql-query-in-batch-apex-start-times-out-even-with-multiple-filter-statements
Regards,
Ashish