SQL SERVER 2019 calls to python take too long time, how to optimize RRS feed

  • Question

  • I want to use sp_execute_external_script to operate Python Statistical algorithm, but here’s the problem: there was a five-sec pause when transfer to pyhon code in store procedure,which leads to a bad response from our customers. I wrote external scripts enabled config_value=1 and run_value=1. 
    In addition, python code runs fast in single Python Executor, but slow in sqlserver store procedure, even the simplest summarize operation. 
    Tuesday, November 17, 2020 9:12 AM