-
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
The Salesforce Customization Dilemma: Get In or Stay Out?
You have your Salesforce solution set up and running and it seems all you’ve got to do right now is relax and enjoy the moment.…
Custom CPQ Solution- Need of The Hour for Manufacturing Firms
Personalizing Salesforce CPQ to maximize ROI for Manufacturing Industries B2B customers are expecting the ease of use and intuitiveness of B2C shopping experiences. But the sales cycle…
Why To Hire A Salesforce Consultant?
Purchasing Salesforce for business operation success is not a gurantee to be successful in the business. Usually when a new organization implements Salesforce they begin…
Popular Salesforce Videos
Salesforce Tutorial - How to Create Custom App in Salesforce
Apps, Tabs, Objects are basic Building Blocks of Salesforce. In this video, I am explaining how exactly you will able to develop a custom app…
How to setup Visual Studio Code for Salesforce ? | Link VSCode with Non Scratch Org using SFDX CLI
Hello Trailblazers, In this video, we're going to learn how we can setup vscode for Salesforce development. I am going to tell you how you…
Reassign Leads using Lead Assignment Rule on Update/Upsert | Salesforce Tutorials | #SalesforceBolt
In this vlog, we will do some work around Assignment Rules. As you are aware Assignment Rule can be trigger on Insert actions. Either it…
