Pyodbc memory utilization issue #1430
Description
I have 10 to 20 stored procedures present in SSMS which accepts table type parameter. Using python i am creating a dataframe which i am storing in temptable and from that temp table i am inserting data into table type and then running the stored procs. While doing the same in SSMS the cpu utilization is 10-12%. But when i am running it from python based azure function the cpu utilization gets a spike upto 79-80%. Upon increasing the cpu core it reduces to 40% but it is still high as compared to SSMS run. Is there a way to optimise the pyodbc driver while running stored procs using python pyodbc driver.