function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Alvaro SevillaAlvaro Sevilla 

monitor to cursors limit in salesforce public sites

Is there any way to monitor and control the limit  to cursors for public sites Salesforce?
Ashish_SFDCAshish_SFDC

Hi Alvaro, 


Need some more information on what exactly you are looking for.

There are no Cursor limits in Salesforce, 

See the below links, 

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 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 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.

https://developer.salesforce.com/forums?id=906F00000008zB3IAI


Salesforce Batch Apex - Invalid Query Locator

http://www.interactiveties.com/b_batch_apex_invalid_query_locator.php


Batch Apex and cursors

http://stackoverflow.com/questions/11055347/batch-apex-and-cursors


Regards,

Ashish