-
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
Getting Into Salesforce? Tips and Tricks You Need to Get your Hands on!
Are you considering getting into Salesforce? Maybe you are thinking of a new career path, your work is migrating to Salesforce, or you just want…
Zendesk and Salesforce Connector - Hassle-free Data Migration from Zendesk to Salesforce
From small businesses to large organizations, data migration is a challenge. Also, keeping the data secure during different phases of the migration process has been…
Salesforce Process Builder: An awesome automation tool
Salesforce Process Builder is an automation tool that helps user to easily automate processes by providing a powerful and user-friendly visual representation of your business logic.…
Popular Salesforce Videos
Winter '21 Release | Salesforce Tutorial Video
The Sandbox Preview window for Winter '21 begun on September 11, 2020. You must have an active sandbox on a preview instance before then to…
Salesforce Confetti | Salesforce Tutorial
In this video, we show you how you can add a confetti cannon to existing paths or create them from scratch. Surprise your staff and…
What is Lookup Relationship in Salesforce?
In this video, Shrey is not only teaching but also demonstrating to you "What is Lookup Relationship in Salesforce?". You will be learning: 1. How…
