XEnvironment is Taking hours to apply downloaded files

Hi Community,

We are experiencing an unusual delay in xadmin deployments on daily basis.

when I analyzed the logs I got to know that the delay was from the xenvironment side. the time gap between "File Downloaded" and "File Applied" is so much that stores are not able to keep up with daily updates. (Deployments are marked as Immediate).

I ran the following query on xadmin DB to get a better view of the situation.

SELECT 
deployment_id, 
store_number, 
create_date, 
DATEDIFF(MINUTE, downloaded_timestamp, applied_timestamp) as timetaken,
downloaded_timestamp, 
applied_timestamp, 
applied_details
from dpl_deployment_file_status
where applied_status = 'SUCCESS' and create_date > '?'
order by timetaken desc;