Performance of PSD 12 Test Window with code Errors

[Benjamin L]

Performance in test windows is a bit ugly while compiling the code. When you try to compile code with any error in PSD 11 it needs 2 seconds to compile in PSD 12 about 10 seconds

Test Code:

DECLARE

BEGIN
lsTest;
END;

 

[Marco Kalter]

Can you let me know how executing this PL/SQL Block is related to compilation with errors? Is the lsTest object invalid and/or are any of its referenced objects invalid? Are they invalid because of errors or because of a change in a referenced object?

 

[Benjamin L]

This was just an example for nonsense code, which results in an error. You can also try

begin
end;

Paste this code in a test window and try to start...

 

[Marco Kalter]

Response is instantaneous in this case.

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

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

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

 

[Benjamin L]

Wasn't sure if i already sent the file to you, but cause there was no reesponse i sent it (again)

 

[MartinSv]

I also noticed this big delay on my PC (Windows 10, 64 bit Developer) with Oracle 11.2 DB

Update: I installed 32bit version of PSD 11.0.6 and the speed increase is quite big, not only in the Test window but even the normal SQL:
'select 1 from dual' takes 0.368s in PSD12_64 and 0.017s in PSD11_32

Update2: tested PSD 12 32bit and it is as slow as 64bit version