Background jobs - excel conversion speeds

[cognosjon]

Afternoon,

I have a simple list report written against an FM package (Dynamic) - 4 dims and 1 fact. Report returns  200k rows of data ( yes i know its not very insightful, but stay with me). When run as a background job and to save as Excel its taking approximately 30 mins to generate the Excel file. Select statement runs and completes in about 30seconds

The same report written against a data module using the same dims and fact but using a data server as its access point. Returns the excel output in less than 2 minutes. Still not supersonic i know, but compared to the FM report its crazy. Its not caching as I have tested with different parameters and get a very similar result.

Anyone have any thoughts on why this could be happening?

Thanks