PLSQL Developer And Performance Decrease by Windows Defender

[Wulff Informatik]

Hello,

an info for all those affected by performance problems with PLSQL Dev - maybe a solution:

I had massive performance decrease in PLSQL Developer, especially when editing and compiling plsql source, but also when calling sql selects from the database. I searched this forum, but found no solution. Then I disabled Windows Defender and - everything ran with very good performance. After reactivating Defender it was slow again. But deactivating Defender forever cannot be not a solution.

Then i remembered, that I had similar problems with my DMS. The solution was to exclude from Windows Defender those processes that started from the direcory where the DMS was installed (C:\Program Files\.myDMS...) So i tried the same and excluded "C:\Program Files\PLSQL Developer 14\*" from Windows Defender, ... and... now its running with good performance, although Defender is doning its job..

Excludes for Windows Defender are declared in "Windows Sicherheit - Einstellungen für Viren- & Bedrohungsschutz - Ausschlüsse" (Sorry, only German Windows at hand).

Maybe it helps others.

Regards,
Hans Peter

 

[Marco Kalter]

Thanks for the info!

 

[Khan Zain]

Hello,

Thank you for sharing your experience with performance issues in PL/SQL Developer and the solution you found. It seems that Windows Defender's real-time scanning can sometimes interfere with the performance of certain applications, including PL/SQL Developer. By excluding the directory where PL/SQL Developer is installed from Windows Defender, you've effectively improved its performance without compromising your system's security.

For others experiencing similar issues, this workaround could be a viable solution. To exclude a folder in Windows Defender, you can follow these steps:

Open "Windows Security" and go to "Virus & threat protection."
Click on "Manage settings" under "Virus & threat protection settings."
Scroll down to "Exclusions" and click on "Add or remove exclusions."
Click "Add an exclusion," select "Folder," and then navigate to the directory where PL/SQL Developer is installed (e.g., "C:\Program Files\PL/SQL Developer 14*").
This should help improve performance while keeping Windows Defender active. It's a good practice to ensure that the applications you use frequently are running efficiently, and this method is a balanced approach to maintaining both performance and security.https://iqratechnology.com/academy/sql-training/

Best regards!