PL/SQL Dev 16 UI is much slower than 15

vlevi

Member³
UI 2-3 time slower, compared to the previous version of PL/SQL Developer.
Mostly noticeable, when I try to use some skin, and when I change from command window to program window. Of courese, small files does not have a big effect on performance, but when I have a program file with 20-30 procedures, or large packages, sometimes I have to wait nearly a minute.
Without any skin, it is a bit better, but cannot be compared to the speed of the version 15 UI.
And of course, the the previous UI-s, for example version11 without the ribbon, were much better :(
But I cannot stick to those older versions, because the new features are useful.
 
When I try this with arbitrarily large program files, switching is instantaneous.

Maybe this is an environment problem. Can you start PL/SQL Developer without connecting, go to Help > Support Info and send me the text from the "Info" tab page?
 
I recorded a small video.

Slow change from command to program window

Support info:
PL/SQL Developer
Version 16.0.6.2170 (32 bit)
Style:
Windows 11 (64-bit) Build 26100
hu-HU(1038)/magyar (Magyarország)

Physical memory : 33 208 520 kB (14 638 740 available)
Paging file : 37 664 968 kB (21 318 068 available)
Virtual memory : 2 097 024 kB (1 586 384 available)

Parameters
C:\Program Files (x86)\PLSQL Developer 16\plsqldev.exe
doublebuffering

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: False

Preference Files
C:\Users\valentl\AppData\Roaming\PLSQL Developer 16\Preferences\default\Default.ini
C:\Users\valentl\AppData\Roaming\PLSQL Developer 16\Preferences\ValentL\default.ini

License File
C:\Users\valentl\AppData\Roaming\PLSQL Developer 14\aalf.dat

Debug file
C:\Users\valentl\AppData\Roaming\PLSQL Developer 16\plsqldev.log

Plug-Ins
*L-Soft komponenskészítés (C:\Users\valentl\Documents\PLSQLDeveloper\plugins\ls_Komponensek.dll)
*Active Query Builder (1.5.1) (C:\Program Files (x86)\PLSQL Developer 16\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer 16\PlugIns\plsqldoc.dll)
(* is Active)

Enabled AI Systems
OpenAI GPT

Aliases
_XEFTP_
airports
ALFAH
ALFAHUMAN
ALFAHUMAN_OLD
...

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)
OraClient11g_home1 (C:\oracle\product\11.2.0\client_1)
OraClient12Home1_32bit (c:\oracle\product\12.2.0\client_1)
OraClient19Home1_32bit (C:\Oracle19\product\19.0.0\client_1)

DLLs
C:\Oracle19\product\19.0.0\client_1\bin\oci.dll

TNS File
z:\Piramis rendszer\OracleInterface\NET80\Admin\tnsnames.ora

Using
Home: OraClient19Home1_32bit
DLL: C:\Oracle19\product\19.0.0\client_1\bin\oci.dll
OCI: version 12.1 (19.3.0.0.0)
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0

Character Sets
Character size: 1 byte(s)
CharSetID: 0
NCharSetID: 1
Unicode Support: False
NLS_LANG: AMERICAN_AMERICA.EE8ISO8859P2
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: EE8ISO8859P2

Process
Working Set = 113 811 456
Memory = 28 672 136
GDI Objects = 1173
User Objects = 745
Handles = 746

Monitor
PixelsPerInch = 96

Id = 0
PPI = 96
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = True
 
I had the other way around. The PLD 15 UI was ultra slow.
When i minimized and restore it, i had to wait 1 Minute (somtimes more), till the UI was ready to use.

With PLD16 the same action needs only 2-3 seconds (!).
I use the the theme "Slate Light".

The change in PLD16 from command window to program window is instantly.
The size of the package doesn't matter. (i have 24k lines in a Package)

But you are rigth: The UI in PLD 12 was much faster...
 
The change of the window type, is only an example.
Most annoying is, for example, copy-paste.
With a big program window, I select 5-6 rows, and press Ctrl-C
I have to wait 2-3 seconds until I can scroll down.
It works instantly in version 14.

One note.
I use the 32 bit version, because we use plugins, wich does not have 64bit version.

I tried the 64bit PL/SQL Developer, and it seems to work much better.
 
Back
Top