"Files" view performance

[mmalecki]

I took the steps:
1. I have enabled Git support
2. I opened the "Files" view
3. I added a directory from the Git repository with about 5000 SQL files with the "Include = *. Sql" option
4. I closed the program.
5. Reopening the program takes a long time (the program does not respond about 5 minutes).

Further:
1. I changed one SQL file
2. I added a filter "VCS = Untracked, Changed"
3. The search takes a long time (the program does not respond for about 5 minutes).
4. After it responds, it is difficult to find the changed file in the nested directory structure.

 

[Marco Kalter]

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\plsqldev.exe" DebugSQL

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

 

[mmalecki]

I probably did something wrong, but after setting the debug mode, I didn't create the file you described.

However, I also noticed:
1. The program starts up slowly even when the "Files" view is not visible.
2. The program starts normally only after I remove the directory from the "Files" view.

 

[Marco Kalter]

Can you go to Help > Support Info and send me the text from the "Info" tab page?

 

[mmalecki]

PL/SQL Developer
Version 14.0.0.1951 Beta (64 bit)
Windows 10 Build 18362

Physical memory : 16 342 900 kB (7 893 084 available)
Paging file : 33 120 116 kB (24 581 056 available)
Virtual memory : 137 438 953 344 kB (137 434 273 060 available)

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

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

Preference Files
C:\Users\user\AppData\Roaming\PLSQL Developer 14\Preferences\default\Default.ini
C:\Users\user\AppData\Roaming\PLSQL Developer 14\Preferences\user\Default.ini

Debug file
C:\Users\user\AppData\Roaming\PLSQL Developer 14\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 14 Beta\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 14 Beta\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
A
B
C
D
E
...

Homes
OraClient11g_home1 (C:\Lokalne\Oracle\Client11gR2win64\product\11.2.0\client_1)

DLLs
C:\Lokalne\Oracle\Client11gR2win64\product\11.2.0\client_1\bin\oci.dll

TNS File
C:\Lokalne\Oracle\Client11gR2win64\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\Lokalne\Oracle\Client11gR2win64\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1 (11.2.0.1.0)
Oracle Database 10g Release 10.2.0.4.0

Character Sets
Character size: 1 byte(s)
CharSetID: 32
NCharSetID: 2000
Unicode Support: True
NLS_LANG: POLISH_POLAND.EE8MSWIN1250
NLS_CHARACTERSET: EE8ISO8859P2
NLS_NCHAR_CHARACTERSET: AL16UTF16

Process
Working Set = 148 705 280
Memory = 40 200 528
GDI Objects = 1329
User Objects = 353
Handles = 685

Monitors
PixelsPerInch = 96

Id = 0
PPI = 96
Primary = False
Handle = 65539
Left = -1600
Top = 0
Width = 1600
Height = 900

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

MainFormOnTaskbar = True

 

[Marco Kalter]

Thanks. I see that there is no DebugSQL parameter. Can you add it (again)? After reproducing the issue the debug.txt file is located here:

C:\Users\user\AppData\Roaming\PLSQL Developer 14\debug.txt