-
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
Use Salesforce Lightning Component in Visualforce Page
In winter ‘16 a new and powerful feature was introduced which allows you to implement your Salesforce Lightning Component in Visualforce pages. There are three…
Why Hire a Salesforce Consultant For Your Business?
The Power of Salesforce: Why a Consultant Can Revolutionize Your Business Salesforce is a powerhouse CRM (Customer Relationship Management) platform, but its true potential lies…
Things to Consider Before Choosing CDP Implementation Partner
Are you looking for a Salesforce CDP integration and implementation services provider and don’t know how to choose the right CDP for your business, then…
Popular Salesforce Videos
Real-time Scenario: Custom Rollup Summaries Using Triggers | Salesforce Tutorial
Watch this video to learn all about Custom Rollup Summaries Using Triggers using the real-time scenarios. If you have any doubts or concerns do let…
Salesforce - How to Create and Debug Process Builders
Check out this video on how to debug Process Builders. Once you really get into building processes in Salesforce in can be confusing as to…
Salesforce Tutorial - Data Loader Installation On Windows - with Zulu Open JDK
Data Loader is utility to perform bulk database operation. Recently Salesforce has changed the way data loader need to be install. I explain end to…
