Author Topic: Background jobs - excel conversion speeds  (Read 108 times)

Offline cognosjon

  • Community Leader
  • *****
  • Join Date: Jul 2006
  • Posts: 246
  • Forum Citizenship: +11/-2
Background jobs - excel conversion speeds
« on: 18 Oct 2021 11:04:28 am »

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?