-
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 Application Development Client On Boarding Features For The Banking Industry
Banking industry has been an integrated part of everyone's life and the process involved to execute Banking operations has been quite slow, until the technological integration for its…
How to Prepare for Salesforce Data Migration in 2024?
In Customer Relationship Management (CRM), Salesforce is a colossus, offering unparalleled capabilities for managing customer interactions, sales, and marketing. However, the transition to Salesforce, particularly…
Salesforce Marketing Cloud Personalization Overview
Suppose you've attracted leads to your website or app. Some of them converted into prospects. You carry on gathering data, but they keep unsubscribing or…
Popular Salesforce Videos
14 Questions Asked in 95% Salesforce Interviews
In this video, Dan Croitor provides a list of 14 questions that are typically asked in Salesforce interviews. He goes over each question in detail,…
How to Become a Salesforce Admin | 6-step Guide
Salesforce administrators are the backbone of any company that uses Salesforce. They are responsible for maintaining the Salesforce platform to ensure it meets the needs…
Methods in Salesforce - All You Need to Know
Learn All About Methods in Salesforce. Watch this video and do let us know if you have any doubts or concerns. What is a Method…
