Performance issues

[Dezsoe Kados]

When connecting via VPN to a remote database the performance is not sufficient. This applies especially to compare operations (timeouts, "user requested the cancel of the current operation"(without requesting a cancel)) etc.

Seems that the a 4K display could be part of the problem, operation "blocks" with the window resized to approx 1/4 of the size for many operations (no only for compare)

Some such problems are already there in 13.0.6.1911 but in this first beta the performance issues are a lot worse.
E.g. the VPN connection issues have been addressed by somebody for version 13 in the regular, non-beta forum.

 

[Marco Kalter]

Compare operations can take quite some time if a lot of database information needs to be fetched over a slow connection. This should never block the application though.

PL/SQL Developer 14.0 should be faster than 13.0 though.

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 14 Beta\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 14 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 14).

 

[Dezsoe Kados]

Will try to generate some test scenarios...

 

[Dezsoe Kados]

Seems that I can not reproduce this in beta 3...

 

[Marco Kalter]

Okay. Thanks for letting me know.