-
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
How to connect multiple accounts to single contact in Salesforce?
Setups to connect contacts to multiple accounts is quite easy and quick. Following are the steps to be followed: Go to Setup, enter Account Settings…
Salesforce CPQ Overview: Installing, Sales Cloud Integration and more
CPQ in Salesforce stands for "Configure, Price, Quote." This Salesforce software is designed to optimize sales processes, specifically product configuration, pricing, and quoting. The…
How To Play Audio & Video Files in Salesforce Through Media Files Player
Salesforce leaves no stone unturned when it comes to customer satisfaction and customer relationship. Ever since cloud computing technology has become a part of our…
Popular Salesforce Videos
How to Close Complex Deals Fast with Salesforce CPQ+
CPQ Salesforce, or Configure, Price, Quote Software by Salesforce is a sales tool for companies to provide accurate pricing with any given product configuration scenario.…
Introduction to Salesforce Apex for Developers
Have you ever wanted to write a Trigger in Salesforce? This workshop is designed for people who would like to begin learning the basics of…
Salesforce Spring ’21 Release Highlights
To improve the platform, Salesforce releases updates three times a year (Spring, Summer, Winter). This is the time for Salesforce Spring ’21 Release. With Salesforce…
