You need to sign in to do that
Don't have an account?
Aruna
Need suggestion and improvement on soql (apex class calls more then 60 soql per transaction )
I need to generate a big report with all the different scenarios and calculations.
you might suggest why don't you use salesforce reporting or other reporting tool :)
But my users wants report in particular formats and different display with colors style etc. So I decided to by using EXCEL functionality which we can do by using API.
I don't have any issue in generating excel but I counted my SOQL , they are already reached to 63.
my question is will it be any problem if only one apex class will execute 63 soqls in one transaction ?
According governer limits we can use 100 soql for Synchronous Limit 100 and Asynchronous Limit 200.
can anyone please suggestion is that ok if only one apex class will execute 63soqls in one transaction
you might suggest why don't you use salesforce reporting or other reporting tool :)
But my users wants report in particular formats and different display with colors style etc. So I decided to by using EXCEL functionality which we can do by using API.
I don't have any issue in generating excel but I counted my SOQL , they are already reached to 63.
my question is will it be any problem if only one apex class will execute 63 soqls in one transaction ?
According governer limits we can use 100 soql for Synchronous Limit 100 and Asynchronous Limit 200.
can anyone please suggestion is that ok if only one apex class will execute 63soqls in one transaction
Can you please pass your code?