You need to sign in to do that
Don't have an account?
niranjan
Long Query Times
Hi,
My process has to retrieve 40,000 records from AccountShare table.
But what I observed the from the execution of the process is that it is taking very long time for the subsequent records.
i.e, it took - 3 hours - for first 4500 records
for next - 3 hours - it processed only 1500 records.
for next - 3 hours - it processed only 500 records
If anyone know why it is taking so long time for the subsequent queries please inform.
Awaiting for your reply.
Regards,
Niranjan.
This process retrieved 40,000 records from AccountTeamMember table and stored in teamMemberDto (in local memory).
queryResult = sfdcClient.query( sql +"'"+ teamMemberDTO.getAccountId() +"'"+
" and UserOrGroupId = "+"'"+teamMemberDTO.getUserId() +"'");
But I observed the from the execution of the process is that it is taking very long time for the subsequent records.
Any suggestions?
Awaiting for your reply.