Question d’entretien chez Accenture

How do you optimize script using awk and sed scripts. Provide example and decrease the run time from 8 hours to 30 mins. Also write a workable program to read a file, parse and load data and extract report in 30 mins.