-
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
Mastering Salesforce Data Migration: A Complete Guide
Salesforce is a leading CRM platform that helps businesses manage their customer relationships efficiently. However, moving data into Salesforce can be tricky. This guide will…
Test Class in Salesforce - All You Need To Know
Below are some of the key points to note about the Test Class in Salesforce: Test Classes and test methods verify whether a particular piece…
Checklist to Hire the Best Certified Salesforce Developer for Business
Salesforce is a powerful Customer Relationship Management (CRM) platform that businesses—irrespective of the industry or domain leverage to manage their customer data and interactions. With…
Popular Salesforce Videos
Engineer More Than Software at Salesforce
Salesforce engineers are builders. Together, we’ve created a platform that helps companies around the world connect with their customers. Driven by our commitment to trust,…
How Trailhead Military can Help You to Get a Job? | The Shrey Sharma Show | Salesforce
Shrey is a Chief Executive Officer at Cyntexa, a SILVER Salesforce Consulting Partner in the USA, UK, UAE, Australia, Singapore & India, having a vibrant…
How to Get Your Data In and Get Insights Out | Salesforce Essentials
Organize all your data with Salesforce Essentials. With a quick and easy import, you’ll be able to manage your business and watch it grow. Essentials…