Windows Client Export to Excel Poor Performance

Products

• Vantage Storage Resource Manager

Issue/Introduction

I was trying to use the Windows Client tool to gather a report of Data Sets. When filtering all the information I need, I kept getting disconnected from the tool and it took multiple hours to get that information transferred from Vantage Windows client to the EXCEL sheet. 
I currently run the Windows 10 security anti-virus. The file had 18,000 datasets and I can't remember the exact size of the file that was being transferred but for another person on the account who ran it on a Linux device it only took 40 minutes. 
This has happened with myself and Co-worker who support the account with me from a different location. We use windows 10 devices and another co-worker who uses Linux only took 40 minutes for the report to be finished. For both of us it took 3-4 hours to finish.

Resolution

Windows Client and WebUI have different architectures and the export functionality is different. 
Windows Client uses Excel to fill the table and is filled continuously while the data is incoming. Transportation Layer sends data in packages from z/OS to Windows operating system, excel takes this data and creates sheets and filling the rows on the fly. 

What can influence speed: Distance from Windows Client (Microsoft windows machine) from z/OS. 

TIP: It has been reported that export is faster when Microsoft Excel is minimized while exporting.

WebUI on the other hand works differently. WebUI back-end server is running on USS and closer to z/OS. While the host collects data, it is transferred to WebUI back-end server, and when it is done, client ( WebUI on user browser) can download the flat file. This reduces network transport and is more efficient. 

Because both UI work in different ways, there is no fix available for Vantage Windows Client which will address this issue. Vantage doesn't have a Client which runs on Linux (Windows client SRM runs on Microsoft windows, and the web Client on USS).