Apex Code Development You need to sign in to do that
Don't have an account?
Amol Jadhav 34 SOQL takes more time for first time execution but subsequent request takes less
I have 5 million Opportunities, I am using vf with SOQL to fetch the Opportunities but for first request it is taking more time and subsquent requests are taking less, below is the sample query
Result = [SELECT Id, Name FROM Opportunity WHERE Name LIKE '%Test%' limit 2000]
a really good question. Here is the answer: https://salesforce.stackexchange.com/questions/25334/why-is-my-soql-query-slow-the-first-time-faster-subsequently
Kind regards,
Chris