Apex Code Development You need to sign in to do that
Don't have an account?
Warjie Query takes too much time
Hi, we have a mulesoft job that do 2 things:
1.) Query & extract records older than 27 months. Normal expected record count is 1M above.
2.) Hard delete the extract records
Before, the query only takes 20 minutes to complete. However we noticed since Saturday and Sunday (June 13, 14, 2015) that the query alone takes too much time (2 hours have passed and only 6% was completed) so we have to abort it.
Can anyone give me thoughts on what could be the possible cause of this issue?
Thanks!
1.) Query & extract records older than 27 months. Normal expected record count is 1M above.
2.) Hard delete the extract records
Before, the query only takes 20 minutes to complete. However we noticed since Saturday and Sunday (June 13, 14, 2015) that the query alone takes too much time (2 hours have passed and only 6% was completed) so we have to abort it.
Can anyone give me thoughts on what could be the possible cause of this issue?
Thanks!
Shashank (Salesforce Developers) It could have been a temporary slowness. Could you please let me know if you are stiil seeing the same delays?