You need to sign in to do that
Don't have an account?
S_2013
Best design approach between nightly job and complex VF report?
Hi guys... I have a system with about 1500 opportunities and there is a field that I need to display on report on Opportunities that must get calculated dynamically.
So one way would be to write a nightly job to update this field in midnight, and display to client.
Another way will be NOT to keep this field on Opportunity object and to use a VF report to dynamically calculate the value and display to client.
My question is, how much detrimental is it for the system to have a nightly job that processes about 1500-2000 Opp. records?
I dont think it will take more than 30 minutes to process few thousands records.
On VF page if data to be displayed is more then you might see viewstate /heap size errors.