-
What are Cursors in Salesforce?
What exactly do we mean if we say "A user can have up to 50 query cursors open at a time".
-
3 Replies
-
Hi Manpreet
a cursor is a reference to the the result set for a soql query.
Select Id, name, (select Id, name from contacts) from account
Will account for 2 open cursors.
The way out was to simplify the soql queries and break what we were trying to achieve in one batch apex class over 2 classes.
Hope it may help
-
Cursors, as I understand, are the equivalent of query result sets. A similar concept exists in SQL if you're familiar with it.
So I'd say a cursor is a reference to the result set for a soql query.
I had a support case with Salesforce a while ago about cursors exceeded in a batch apex query. Apparently even inner queries will account for their own cursor set
So
Select Id, name, (select Id, name from contacts) from accountWill account for 2 open cursors.
The way out was to simplify the SOQL queries and break what we were trying to achieve in one batch apex class over 2 classes.
-
Cursors : It is equivalent to the Soql query result set. In cursor a user can have up to 10 query cursors open at a time. If 10 QueryLocator cursors are open in the application and the same user, attempts to open a new one, then the oldest of the 10 cursors is released. If the client application attempts to open the released query cursor, an error results.
Log In to reply.
Popular Salesforce Blogs
Salesforce Interview Question - Part 5
1. What is an Object? An object in Salesforce is a fundamental data structure used to store and manage data. Objects can represent various types…
Salesforce® Summer’17 To Raise The Temperature This Season!
Anticipation and excitement start as soon as news of Salesforce update hits the market. Salesforce® is known for an average release of 200 plus features…
Meet The world's First Real-Time CRM - Salesforce Genie
The most awaited, magnificent event, Salesforce Dreamforce 2022 was an incredible experience with a series of significant updates and announcements. Upcoming blogs will unravel all the…
Popular Salesforce Videos
Introduction to Salesforce CTA Exam
The average salary for a Technical Architect is $118,324 per year in the United States. Do you also want to become Technical Exam by cracking…
Salesforce Work.com New Features
Work.com includes new solutions to accelerate the private and public sector's answer to the COVID-19 pandemic, ranging from contact tracing and emergency response management to…
Introduction to Salesforce Orchestrator
Flow Orchestrator was created so admins like you can quickly create sophisticated multi-user, multi-step automated business processes with clicks, not code. Experienced Salesforce Admins will…
