PL/SQL Developer takes forever to load.

[Rahul P]

I was trying to figure out why PL/SQL Developer takes forever to load. And I browsed thru the 'application data' directory and found a file in 'PFInfo' directory called 'files.info'. I see that it's 362kb. Looked thru the contents of it and looks like 'size' settings for the files we use for our source control.

1). Would the size of this file affect the loading of PLSDEV?
2). I would like to know how to disable writing this file settings so that the file doesn't bloat.
3). I see that the settings are of the files that we no longer use in our project anymore or moved over to different names AND locations. So, my question is if I can safely delete the file. Question 2's answer would help in figuring out future writing of this file.
4). Kind of related to this one, so, here it is. Where can I delete the 'projects' in the drop down in the setup of the VCS Plugin. I see that there are projects here that we no longer use. I tried to delete them from the actual Visual SourceSafe settings, but, they weren't mentioned there. Obviously these settings are local to the VCS plugin and I would like to delete the obsolete ones for us.

 

[Rahul P]

I might have partially answered my own question(s).

For 3), I was able to safely delete the file and PLSDEV worked fine. And I noticed that the file gets 'written' soon as I close the program file I just closed.

So, For 2), I might have found the answer. Go to:
Preferences -> Window Types -> Program Window -> Save Window State (position, size, bookmarks, ...) and 'uncheck' the box. This won't write into the files.info file.

But, I noticed that for 1), the file.info filesize doesn't affect the loading of PLSDEV.

So, my question changes.

1). What is slowing down the loading of my PLSDEV.
2). I still need the answer for question 4) in the previous post.

Thank you.

 

[Killservice]

ad 4) if I right understand your question ;-) see windows registry
[HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\ProjectHistory\

 

[Rahul P]

Perfect. That worked. Also, while I was at it, I saw the 'BrowserMRU' thing had around 50 entries in my profile.

It's scary how many settings there are.

So, for now, 4) is fixed. Thank you.

But, 1) in my second post still remains. It takes around 10 seconds for it to pull up. PLSDEV.

But, sqlplus connects instantly. So, I know it may not be the database connection. This whole time lag is AFTER the splash screen is gone. HELP!!

 

[Marco Kalter]

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).

 

[Rahul P]

Marco,

Thank you for your help. I sent the debug log file you requested. Please let me know.

Also, btw, the debug.txt was in the PLSDEV install directory itself for me. Not in APPDATA folder.