-
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 and Slack AI: A Synergistic Partnership
Salesforce and Slack, two industry-leading platforms, have formed a powerful alliance to revolutionize the way businesses operate. By integrating AI capabilities, this partnership offers a…
How to Design Salesforce Approval Processes for Complex Business Workflows
Growing businesses often require several levels of review before approving discounts, contracts, expenses, purchases, and customer requests. Manual approvals can create delays, inconsistent decisions, and…
Top Dreamforce '21 Announcements | Salesforce
Dreamforce 2021 came to an end last week with full-fledged releases, launches, and announcements. There were a lot of learnings, fun, and festivities alongside networking…
Popular Salesforce Videos
Salesforce AppExchange Pricing Models
Salesforce AppExchange offers a wide range of solutions and applications designed to enhance and extend the functionality of Salesforce. However, understanding the pricing models can…
Overview of Salesforce Development Course
In this video, Shrey has given a detailed overview of the Salesforce development training. You will learn the following topics from this course: Apex basics…
Streamline Sales Goals and Add Value to Your B2B Organization With Salesforce Marketing Automation
Salesforce Marketing Automation enables businesses to automate marketing processes, track customer engagement while delivering personalized experiences to each customer. With it, you can streamline and…
