Apex Code Development You need to sign in to do that
Don't have an account?
Sam27 query is taking inconsistent time...........
I am running a rather large soql query consisting open activity, activity history opportunity and contact as the root item with similar large where condition.....
Now what the problem is that the execution time of query is very inconsistent......
sometime the query (always for fewer data) runs in the time of one second but sometime (specially with large set of data) the query take inappropriately long time to execute (50 -200 seconds)
What i don't understand is the ratio between the amount of data is not proportional to the ratio between the amount of time its taking....i. e. ideally it should take little more time to execute (if any) but its something like hanging....
Anyone can suggest the ways to solve it , or suggestion to improve the query structure to get rid of this inconsistency....
or have any of you faced similar situation in dealing with soql query......??
Any suggestion and comment is welcome
Thank you
I am getting the same issue, i am hitting my head on walls :'( , but database is still very inconsistant.