-
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
Relationship Queries in SOQL | Salesforce Tutorial Guide
Relationship field contains at least 2 Objects i.e a Child Object and a Parent Object. These queries are used to fetch Data either from the…
Compare Salesforce Profiles Easily with BOFC
Why Compare Profiles in Salesforce? Salesforce Profiles define user permissions, field-level access, object-level access, and system privileges. When you manage multiple profiles (like Sales, Service,…
Here's What Slack - Salesforce Integration Have in Store for You
Communications, process integration, and connectivity get complicated to handle as the firm or corporation grew. When your staff work remotely, keeping in touch with them…
Popular Salesforce Videos
Prepare for TrailheaDX: Everything Salesforce Admins Need to Know
TrailheaDX is a one-of-a-kind virtual experience that connects makers, builders, doers, and dreamers looking to improve their Salesforce skillset. This year’s event includes exciting new…
Salesforce Field Service Implementation
The possibilities for building a custom field service implementation are nearly endless when considering all the offerings in Salesforce Field Service. This 8-step guide provides…
What is Salesforce Integration? | Saleforce Integration Explained
Learn how to seamlessly connect different tools and data sources with your Salesforce platform. It's all about making informed decisions and gaining a competitive edge!…
