You need to sign in to do that
Don't have an account?
Fahad Khan 2
Query execution Delay, too much!
I have an apex rest webservice and it has query where it takes around 30 to 40 seconds to execute. query is as follows and debug logs are attached. Funny and frustrating thing is for the first time when i call that WS it takes 30 to 40 seconds but if i try to call the same again it takes no time to execute. and if i wait like 1.5 to 2 hours and try again to execute that call it again takes 30 to 40 seconds. I am not sure if oracle keeps compiled queries or what. please help. Thanks in advance
SOQL: [Select ActivityDateTime, subject
From Event
Where ActivityDateTime > :now and
isChild = false and
(/*Subject Like '%handover%' OR*/ Subject Like '%survey appt%' OR
/* Subject Like '%remeasure%' OR Subject Like '%spot check%' OR*/
Subject Like '%misc appt%' OR
Subject Like '%showroom visit%' OR Subject Like '%general appt%' ) and
ActivityDateTime <= NEXT_N_DAYS:14 ]
Debug logs both executions:
SOQL: [Select ActivityDateTime, subject
From Event
Where ActivityDateTime > :now and
isChild = false and
(/*Subject Like '%handover%' OR*/ Subject Like '%survey appt%' OR
/* Subject Like '%remeasure%' OR Subject Like '%spot check%' OR*/
Subject Like '%misc appt%' OR
Subject Like '%showroom visit%' OR Subject Like '%general appt%' ) and
ActivityDateTime <= NEXT_N_DAYS:14 ]
Debug logs both executions: