I'm struggling with getting a U-SQL script to run in a sane amount of time.
I originally transcribed the script over to U-SQL from an in-house language called SCOPE, but several native functions in SCOPE are missing from U-SQL, so I had to find ways to write them myself.
Early on, I assumed that these features would be faster if I replaced them with SQL, but due to how long the script is taking to run, I'm beginning to question that assumption.
I am currently planning to start doing some experiments on this exact topic, but if anyone already happens to know the answer, I would really appreciate your help. If no one responds, I'll try to answer my own question here to help anyone else who finds themselves having a similar issue.