Apex Code Development You need to sign in to do that
Don't have an account?
zubair shareef mohammad 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