sp_execute_external_script can take a while to initialize when not run for a short time. How do I set the idle time on the controller Launchpad process to keep it from shutting down too soon?
Note I am not talking about reusing the same Python session as I know each call uses its own session. What I am referring to is that when you execute
sp_execute_external_script for a language it takes a while to start up. If you call
sp_execute_external_script again in a short time then it runs immediately. However, if you wait a while and execute it again it takes a while to execute as (I think) the Launchpad controller has reached an idle time and shutdown. See this article about SQL Server using the Launchpad process to created links to Python, R, and soon Java.
Is there a way to increase this idle time?