-
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
Spring'24 Updates in Salesforce for Developers
This article is prepared by our Salesforce Developer Aliaksandr Sheuka. Apex Enhancements Null Coalescing Operator (??) The ?? operator returns the left-hand argument if the…
Master the Art of Customer Service with Case Management | Salesforce
What is the top priority for any business today? If you anticipated it as ‘Customer Experience’, you are probably right. Recent research found that nearly…
Salesforce Marketing Cloud and its Benefits - Learn Here
Marketing Cloud is an automation platform praised around the globe and is the most feature-rich in its class. It provides incredible insight into customer journeys…
Popular Salesforce Videos
Marc Benioff & Aneel Bhusri On Ensuring a Safe Return to Work | Leading Through Change | Salesforce
In this week’s Leading Through Change, join Aneel Bhusri the Co-Founder and CEO of Workday and Marc Benioff the Chair and CEO of Salesforce as…
Salesforce Stock CRM Huge News!
Why is Salesforce Stock CRM Stock going UP? Is Salesforce stock a buy? Should I buy CRM Stock? Is Salesforce stock a good investment? In…
Salesforce Apex Trigger Best Practices | Learn Salesforce Series By Algoworks
In this video, the following points will be covered - 1. One Trigger Per Object 2. Logic-less Triggers 3. Context-Specific Handler Methods 4. Code Bulkification…
