PSD 9.0.X very slow?

[Stew Stryker]

Ever since I upgraded to 9.0.0, operations have seen much more sluggish than before. Enabling multiple connections seems to exacerbate the problem, but turning it off doesn't eliminate the problem entirely. It's to the point where it's not usable and I'm moving back to PSD 8.x.

Slow steps:

• Initializing a test window to execute it - Just took 10 seconds
• Describe table via right-click - Just took 8 seconds
• With multiple SQL/code windows, sometimes just moving between them is very slow (up to 15 seconds). The only seems to occur with multiple connections enabled, otherwise is fine.

I'm on a new, fairly powerful laptop running Windows 7 on Oracle 11g R1.

Others on my team haven't upgraded and things are running fine for them. Maybe it's something in our database configuration that PSD 9 has changed, but it's a shame because I liked using the multiple connections feature a lot.

[sigh]

 

[Jerry12]

Hi Stew,

No you are not alone, Ever since upgrading to 9.0 it has become extremely slow. Just querying a table seems an eternity. The only thing that has changed is my version of PL/SQL.. I am hoping they have realized this and an update will be coming soon.. if not I will just roll back a version and not update...

 

[Stew Stryker]

Jerry,

Thanks for letting me know it's not just something I messed up (which was definitely an option!). I rolled back a little while ago and it seems better.

Stew

 

[Marco Kalter]

Updating to the current 9.0.1 version should fix all performance issues. If you still have problems with 9.0.1, let me know.

 

[Stew Stryker]

Marco,

Sorry that I didn't mention that I was up to the latest 9.0.1 version. I was still having troubles with that.

I think I just emailed you a Support Info extract a couple days ago. Please let me know if you need another copy.

Thanks,

Stew

 

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

 

[Stew Stryker]

Marco,

Digging further, it looks like at least some of the fault lies with how long it takes to connect to our various databases. Over our internal network, a production connection takes a second or less, the pre-production and development instances can take up to 23 seconds!

So that explains why the V9 multiple connections option seems much slower. I'm also wondering if V9 might have changed when/how it's performing some operations, requiring more connection events? But that's just a WAG.

And I need to talk with our DBAs about why connection times are so slow!

My apologies for disparaging V9. The slowness seemed to coincide with the upgrade to V9.

 

[Marco Kalter]

Okay. If you switch connections a lot and connection is slow then version 9 will actually be faster because it preserves all previous connections .