How to optimize Demand Plan extraction - ESS job is taking 3-3.5 hours of time.

Summary:

How to handle the size of files and time taking to extract the data from demand plan?

We are extracting the publish data of Demand plan using the ESS job. It is run daily once.

This job is taking 3-3.5 hours of time to complete the extraction and place the files into content server.

The files are very huge (size is 42658449) and this job generates 6 zip files.

But from last two days it is generating 7 zip files.

Content (required):

We are extracting the publish data of Demand plan using the ESS job. It is run daily once.

This job is taking 3-3.5 hours of time to complete the extraction and place the files into content server.