21.3.2 on premise.
Running an MDX script through a Maxl shell, writing output to a txt file.
The script and the process works, the MDX script in question writes about 1.8 million rows to a txt file. The query portion takes about 6 minutes (message shows up in the log file for the app). However the script takes 20 minutes plus to write the results to a txt file.
If I run the same MDX script from the web interface the script and the output to a txt file takes about 6 minutes total.
I'd like to run it from the Maxl Shell, however is there anyway to speed up the writing of the output to a txt file? It has to be possible because it writes so much quicker when run from the web interface.