+ Start a Discussion
mayank_friend52mayank_friend52 

SOQL difference?

Hello,

Is there any time difference if I query for 2000 or 50,000 records (Standard or Custom Object) through SOQL .
And if i use query through AJAX, then is there any time difference for the same.

Thanks,
Mayank 
Vinit_KumarVinit_Kumar
The SOQL limit whether standard or custom object is 50000 records returned per query.

It does not matter how you query it through AJAX or Apex or API.

If this helps,please mark it as best answer to help other :)
mayank_friend52mayank_friend52
Hello Vinit,

Thanks for the response.

But I have one more question,  

When there are 2000 records it takes less time than when there are 50000 records to show in the Active Widgets.

Please explain me why this is happening.


Thanks,
Mayank

Vinit_KumarVinit_Kumar
Isn't that expected??

As the no of records are more query would take time to respond and hence the delay..

Hope this helps !!
mayank_friend52mayank_friend52
Hello Vinit,

Thanks for the response.

"What causes that delay, Time taken by the SOQL query to fetch 50,000 records or Time taken in binding those 50,000 records in an active widget".

Please reply.

Thanks,
Mayank