You need to sign in to do that
Don't have an account?
![zubair shareef mohammad zubair shareef mohammad](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Using soql
Hi, this is zuber
1) Using Soql quiers can we fetch 1 lakh records ?
2) by using Soql, I am fecthing 1000 records if it takes 1 min to fetch then how can we reduce the fectching time ? Is there is any way ?
3) How to reduce the number of soqls in a transaction ?
Please give me clear description on this topics
Thank you
1) Using Soql quiers can we fetch 1 lakh records ?
2) by using Soql, I am fecthing 1000 records if it takes 1 min to fetch then how can we reduce the fectching time ? Is there is any way ?
3) How to reduce the number of soqls in a transaction ?
Please give me clear description on this topics
Thank you
show me your query it wont take that mouch of time .
you can follow this document .
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm
https://trailhead.salesforce.com/en/apex_database/apex_database_soql .
regards,
harish.R
1) Using Soql quiers can we fetch 1 lakh records ?
- In Apex there is limit of records you can fetch in one transaction which is 50K.
2) by using Soql, I am fecthing 1000 records if it takes 1 min to fetch then how can we reduce the fectching time ? Is there is any way ?
- To reduce the time of fetching you need to user filters with Indexed field like Id, Name.
3) How to reduce the number of soqls in a transaction ?
-Strange,about this question. A developer should know the use cases for which the block code has written and depend the use cases and follow the best practise to reduce the soqls.
@Harish has already provided the links of documentations.
-Thanks
Ashlekh Gera