+ Start a Discussion
James L.James L. 

Is the child-parent lookup field in SOQL counted as 2 records for apex limit ?

Hi,

 

Apex limit: Total number of records retrieved by SOQL queries: 50,000

 

for  SOQL like [select ID, Account.name from Contact]; from limit perspective, every returned row contributes to the Max limit as one record or 2 records?    the "2 records" ideas came from "The returned result is actually composed from 2 backend tables"

 

James

Jia HuJia Hu

In you case, it is counted as 1 row, query like

select id, account.name from contact limit 1  

and you can check the result from debug log

James L.James L.
Thanks