[Python] Significant Python Script Performance Degradation in PowerShell/Batch After Windows...

I hope you're all doing well!

I need some help regarding the execution of Python programs under PowerShell.

I have a basic ETL solution developed in Python that extracts data from Excel spreadsheets, saves it to an SQLite3 database, and subsequently processes the data to generate new spreadsheets with different views and summaries.

I developed this program using the PyCharm and VS Code IDEs, and given its complexity, the program executes in an acceptable time within the IDEs (approximately 30 seconds).

For practicality, I created a PowerShell script to invoke the Python runtime and execute my program. Initially, everything was fine, but I noticed that after a Windows 11 update, the program's execution time increased almost threefold, going from around 30 seconds to over 90 seconds. However, when I run the same program through the IDEs, the original execution time of approximately 30 seconds remains.

I've already converted this PowerShell script to a MS-DOS Batch file, and the slowness issue persists.

I would like to know if there's any Windows configuration I can adjust so that the execution time returns to what it was before.

Here is my Windows 11 Pro version information:

Edition: Windows 11 Pro Version: 24H2 Installed on: October 29, 2024 OS build: 26100.3775 Experience: Windows Feature Experience Pack 1000.26100.66.0

Continue reading...