I suspect network is as much of a problem as anything. Files are on a server in HK. I'm WFH in the UK. Am using Pentaho PDI to do it, but even directly in Windows its just sloooow.
It sounds like you are querying the HK server (whether via DB or command line) from your local machine?
If network is an issue, can you connect to the server directly and run the command line there? Or e.g. remote desktop into another machine in HK, say a colleague's desktop and do it from there?
I suspect network is as much of a problem as anything. Files are on a server in HK. I'm WFH in the UK. Am using Pentaho PDI to do it, but even directly in Windows its just sloooow.