Code Assistant Performance

[suess]

Hi

Code Assistant performs very badly with large databases. It can take 30s for code assistant to populate with our database. Which is fine, except that it doesn't cache anything and so the very next owner/table/function that invokes it takes another 30s. Therefore it must be turned off for us. The database is 2 node RAC running on SSD, so it operates very fast, but does have tens of thousands of object and millions of lines of code.

I would really like to see the code assistant operate in a background thread, and not retrieve the entire database every time it's invoked blocking the main application thread.

Unless someone else has a better idea, or suggestion? My whole team has it turned off and we manually look for things.

Thanks,

Brian

 

[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 14 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 14).

 

[suess]

Hi Marco

I already did that a long time ago and sent you PM via the forum with the debug information attached.

Brian