-
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
Salesforce Consulting Services - 8 Excellent Salesforce Tools to improve your Sales Pipeline
Ever asked any sales organization which technology they have heavily invested as an alternative to the CRM? The answer is Salesforce which has now become…
Insert and Update multiple custom metadata records through Salesforce Apex.
Hi Folks, as we all know Salesforce has limitations while performing any kind of DML Operation on custom metadata (.mdt) objects records. Even though there…
Top Salesforce Spring '23 Service Cloud Features
With the all-new Salesforce Spring '23 Service Cloud features discover new capabilities that will assist you and your team provide efficient, high-quality service. Share links,…
Popular Salesforce Videos
Salesforce - How Small Businesses Offer Great Customer Service
Small businesses are more than capable of offering great customer service, even without having a big call center or multiple service agents on hand. For…
Soar: A Salesforce Philanthropy Film
When one of us is lifted up, all of us are lifted up. 🐥 That's why we're supporting #GoGiveOne, a campaign to advance global vaccine…
Unleash the Power of Compare Tables | Salesforce Video
In this video, you will learn how to use compare tables to calculate complex calculations quickly, which you can then use to visualize your data.…