-
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 Tail logs in Browser (No CLI Installs)
Are you still watching tail logs in terminal or CLI windows? We are delighted to announce that we have released a brand-new version of our…
How to Override Standard Buttons With Lightning Component?
A Lightning component is required to implement lightning:actionOverride interface to be used to override a standard action on an object. You can override the View,…
Salesforce Implementation Checklist: 9 Steps to Success
Through it all, Salesforce continues to remain one of the largest players and one of the best platforms in the market. But we all know…
Popular Salesforce Videos
Automated Lead Conversion: Triggering Success When a Lead is Born!
Benefits of Trigger-Based Conversion Instantaneous Response to New Leads Improved Lead Nurturing and Engagement Streamlined Sales Process for Maximum Efficiency Data-Driven Insights for Continuous Improvement…
Salesforce Object Query Language (SOQL) Crash Course | The Complete Hands-on Tutorials
SOQL in Salesforce is used to retrieve data from the Salesforce database for specific information. This video covers everything you need to know as a…
Salesforce Lightning Events Tutorial I Building Component Events (Single Component)
This Salesforce Lightning Events Tutorial will make you learn how to register an event in Salesforce Lightning and handle that event in the source component…
