Latency when clicking on table data

[Stian]

Hi,

Just clicking cell or somewhere in the table freezes the whole application for 15-30 seconds every time I execute a query. This is very annoying and I can not understand why there is need for network round trips for this. The data should already be transfered.

FYI, I am working as a offshore resource and have a very slow VPN with bad latency.

PS. To begin with PD was almost useless, but turning off all auto complete I could find it's just bearable.

Regards
Stian

 

[Marco Kalter]

If you go to Tools > Preferences > SQL Window you can disable the "Show dictionary information in result grid" option. This will prevent the delay.

 

[Stian]

Thanks Marco

Do you have any other tips disabling as many lookups as possible?

For exsample, I get a delay for 5-10 sec very often when I just click to select a variable name or procedure name when editing SQL og PL/SQL. I'm not talking about right clicking, only single left click.

 

[Marco Kalter]

Performance optimizations when working on a slow VPN:

• Install PL/SQL Developer locally
• Have your Application Data directory (%APPDATA%) on a local drive
• Have your source files on a local drive.

Now PL/SQL Developer will only use the network for database activities. To minimize database activities:

• Disable the Code Assistant preference "Automatically activated". Now you need to press F6 to invoke it.
• Disable the Code Assistant preference "Describe context".
• Disable the SQL Window preference "Show dictionary info in result grid"