-
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 Partner Learning Camp: A Trailhead for Partners?
Created exclusively for Salesforce partners, Salesforce Partner Learning Camp (PLC) is the primary educational resource for building service capabilities to meet customer demands. After Salesforce…
How to do Salesforce Customization Right?
When it comes to serving potential customers while balancing the sales of the business, Salesforce has unlocked countless opportunities for us to get involved. It…
More About Salesforce Custom Objects Behavior
Utilize the accompanying points to work out how the API communicates with custom items and fields: Naming Conventions for Custom Objects Relationships Among Custom Objects…
Popular Salesforce Videos
How to Create a Jira Ticket from Salesforce?
Learn how to create a Jira ticket in Salesforce using two different methods and how to choose a Jira project. Know more at https://www.sinergify.com/
How Link Cartridge Development Can Your Business Storefront | Salesforce Link Cartridge
LINK Cartridge is a container for packaging and deploying program code and data, it’s structured in folders and subfolders for maximum efficiency.
Learn REST APIs and Integrations Basics in Salesforce Development
In this video, we will learn about REST APIs & Integrations Basics in Salesforce development: We will be discussing the following things in this video:…
