+ Start a Discussion

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 think you should go for a batch job.
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.