-
Query Exception
I got error "System.QueryException: Non-selective query against large object type (more than 100000 rows)" when i used in my prod environment. This is due to the no. of records in the org which are queried are about 3 lacs.What should be done in this case to counter this error. I am using query as leadlist=[select id from Lead where phone IN:phone] here phone is a standard field
-
1 Reply
-
Yes, that means it's taking too long. A couple ways to get more CPU time are to put the code in an @future method (you get 60 seconds of CPU instead of just 10 seconds), or implement it as a Batch Apex job. Since both of these methods are asynchronous, the trigger and associated DML will complete before the calls to the AccountServices methods are made - but they will be called eventually. Would this work for you? or Try to filter your query to reduce number of records.
Log In to reply.
Popular Salesforce Blogs
How To Process Large Records in Salesforce Without Hitting the Governor Limits
Batch Classes: - Batch Apex is exposed as an interface that must be implemented by the Salesforce developer. Batch jobs can be programmatically invoked at…
CPQ Deployment Process: Top Challenges and Best Practices | Salesforce
What is CPQ Deployment? CPQ (Configure, Price, Quote) software is a powerful tool that helps businesses streamline their sales processes. It allows sales teams to…
Here's What To Expect From Salesforce's TrailheaDX 2021
TrailheaDX is the year's most exciting event for Trailblazers who want to learn new ways to build apps on Salesforce and expand the Salesforce Customer…
Popular Salesforce Videos
Add Intelligence to Any Salesforce App with Einstein Discovery
Bring intelligence in the context on any Force.com app thanks to the power of Einstein Data Discovery. Any Salesforce Admin or Developer can add in…
Tableau CRM for Emergency Response Management | Salesforce
When disaster strikes, public and private health organizations, as well as government agencies, need to respond quickly and efficiently. Tableau CRM for Emergency Response Management…
Salesforce Administrator Preparation - ADM 201
Salesforce Administrator Certification exam does not require any specific pre-requisites. But any working knowledge as an administrator or a developer or a functional consultant will…
