SOQL VS SOSL explained with a real time Example

SOQL vs SOSL,soql vs sosl explained with a real time Example, soql vs sosl example, soql, sosl, sfdc panda, dineshkumar rajamani, salesforce developer, salesforce tutorial, real time example on salesforce,

SOQL vs SOSL explained with a real time example!

SOSL(Salesforce object search language) simplified :-

Facebook graph search is much-a-like SOSL, After searching something you can see results returned from name,post, pages which in turn like returning a List of list of sObjects.

SOQL(Salesforce object query language) simplified :-

SOQL is like searching your Facebook friend list which in turn like returning a List of sObjects.

Tabular comparison :-

SOQL
SOSL
Data retrieval done via using ‘SELECT’ keyword
Data retrieval done via using ‘FIND’ keyword
Data retrieval from single object plus related objects
Data retrieval from multiple objects.
Much-a-like querying on single table
Much-a-like querying on Multiple table
SOQL and SOSL generally have the same limitations
SOQL and SOSL generally have the same limitations

Governor Limits on SOQL and SOSL :-

SOQL Limits ->

Total number of SOQL queries issued in synchronous mode is 100, where in asynchronous mode it is 200,  records retrieved by SOQL queries is 50,000.

SOSL Limits ->

Total number of SOQL queries issued is 20, records retrieved by SOQL queries is 2,000.

Click me for SOQL coding Example 

Click me for SOSL coding Example 

Click me for salesforce developer guide on SOQL and SOSL

 

 

Be the first to comment

Leave a Reply

Your email address will not be published.


*