v11.0.3.1770 - Slow code parsing?

[DmitryP]

Our team recently moved from PL/SQL Developer v10.0.5 to v11.0.3.1770 and all of us experienced significant delays while navigating through big package bodies (about 5-10 thousands lines).

From my own experience most significant delays happens while caret placed in big chunk of commented code. E.g. comment around 2000 lines in 9000-line package, then try to place caret at the middle of comment and navigate with keyboard arrows.

Also there are a significant delays while searching for string in big package bodies.

Is any workarounds exists to speed up navigation through code?

Refactoring to smaller packages is not a choice for us because we deal with very big legacy system

Below is some data from "About" box:

Version 11.0.3.1770
  11.92312 - Unlimited user license
  Service Contract: 2015-01-01
  Windows XP Professional 5.1 Build 2600 (Service Pack 3)

  Physical memory : 2 097 152 kB  (2 097 152 available)
  Paging file     : 4 194 304 kB  (4 082 072 available)
  Virtual memory  : 2 097 024 kB  (1 467 584 available)

Parameters
  C:\appwin\PLSQLDev\plsqldev.exe

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

Plug-Ins
  *Active Query Builder (C:\appwin\PLSQLDev\PlugIns\ActiveQueryBuilder.dll)
  *PL/SQL Documentation (plsqldoc) (C:\appwin\PLSQLDev\PlugIns\plsqldoc.dll)
  *Reconnect v1.0 (C:\appwin\PLSQLDev\PlugIns\Reconnect.dll)
  *Red Gate Deployment Plug-In (C:\appwin\PLSQLDev\PlugIns\RedGate.dll)
  *Information v1.0 (C:\appwin\PLSQLDev\PlugIns\selection_info.dll)
  *Version Control Interface 1.2 (C:\appwin\PLSQLDev\PlugIns\VCS.dll)
   (* is Active)

Using
  Home: OraClient11g_home2
  DLL: C:\ora11g\product.2.0\client_1\bin\oci.dll
  OCI: version 11.1
  Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

Character Sets
  Character size: 1 byte(s)
  CharSetID: 171
  NCharSetID: 2000
  Unicode Support: True
  NLS_LANG: AMERICAN_AMERICA.CL8MSWIN1251
  NLS_CHARACTERSET: CL8MSWIN1251
  NLS_NCHAR_CHARACTERSET: AL16UTF16

Monitor
  Id = 0
  Primary = True
  Handle = 65537
  Left = 0
  Top = 0
  Width = 1600
  Height = 900

  MainFormOnTaskbar = False

 

[Marco Kalter]

As a test, can you go to Tools > Preferences > Editor, disable the "Highlight parentheses" option, and try again?

 

[DmitryP]

Marco, thank you for cooperation!

I tried to switch off "Highlight parentheses" feature but this didn't help. GUI freezes for a long time even if I switch off all syntax highlighting features, open new instance of PL/SQL Developer without database connection and load only text of single problem package with body from file.

I can't send you original code because of DNA but has prepared a test package by replacing all meaningful information with random strings.
To reproduce problem download archive with package source from this link:http://www.fast-files.com/getfile.aspx?file=94243 , open it in PL/SQL Developer, go to line 5460 of package body and try to navigate around.

 

[Marco Kalter]

Thanks, I have downloaded the file and we will check it out and will get back to you.

 

[Ameen]

I have faced the same problem with 20000+ package body, but that when I was using pc with 1.2GHz processor, now I am using pc with dual core 3GHz processor and the performance is good.
Some lags caused by the server though, so try to uncheck (describe standard functions and other similar options in code assistant options).

 

[DmitryP]

Ameen, thank you for recommendations, but this didn't help. Lags happens even if PL/SQL Developer not connected to server.

Also, we work on many projects on virtual machines with help of VPN and Remote Desktop Client, so we limited in client PC resources at most cases and can't upgrade hardware.