pyodbc icon indicating copy to clipboard operation
pyodbc copied to clipboard

Pyodbc memory utilization issue

Open rajban94 opened this issue 5 months ago • 0 comments

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.

rajban94 avatar Jun 11 '25 18:06 rajban94