Print Thread
Page 1 of 9 1 2 3 4 5 6 7 8 9
Slow response
#50931 03/03/15 04:01 PM
Joined: Sep 2008
Posts: 34
C
Member
OP Offline
Member
C
Joined: Sep 2008
Posts: 34
Hello,
Im reposting this topic from beta-forum, which seems to be closed.

Environment of version 11 is noticeably slower than previous version 10. It's hard to define all (slower) actions, I can describe one very simple operation. Steps are:
- start PLSQL Developer (without any connection)
- open 10 new "SQL windows"
- connect to (any) database (it makes all 10 windows connect to database)
- and now: just close all 10 windows as quickly as possible smile

I joined an attachment of screen captures - ver10 and ver11. This simple actiona takes me about 15sec in ver10, but 30sec in ver 11.

This is just example (I dont' enjoy closing ten windows every ten minutes) but there're a lot of actions slower than ver10 which is annoying, so I have to stay with 10 for now.

plsql10 screencapture

plsql 11 screencapture

Thanks for response.
David

Last edited by czdavidm; 03/03/15 04:02 PM.
Re: Slow response
czdavidm #50934 03/03/15 06:43 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
We're looking into this.


Marco Kalter
Allround Automations
Re: Slow response
Marco Kalter #50952 03/05/15 02:46 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
I find this behaviour really annoying too. Version 11 spends it life a lot more in sand clock-mode for no obvious reason. Just switching between the windows of my project already takes lots of time. There's also the really irritating effect that you click somewhere and for several seconds nothing seems to happen at all. Another effect is that with some of such long time taking actions in task-manager the instance seems to split for a while and then re-unites before becoming usable again. I'm currently thinking about using version 10 for now again, as version 11 doesn't seem to really be mature enough yet to be used productively.


Regards,
Berny
Re: Slow response
Bernhard S #50956 03/05/15 05:20 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
I have done some further research. I have a project with 33 windows.

1. Opening this project takes
about 1 min 50 sec in v11 compared to 1 min 40 sec in v10.
=> About 3 sec per window is not acceptable and should have been faster in both v11 and v10.

2. Clicking through all my 33 project windows takes
about 2 min 10 sec in v11 compared to 1 min 00 sec in v10.
=> That is not acceptable in v11 while it was just about ok still in v10.

3. Closing this project takes
about 20 sec in v11 compared to just 3 sec in v10.
=> Not acceptable in v11, was fine in v10.

The reason why I keep quite a lot of windows open in my projects is that they often use a lot of different connections and without keeping the windows open I would loose the info, which project item should be opened with which connection. I would much rather prefer to have that info stored in the project items themselves already and have them remembered when reopening project items.


Regards,
Berny
Re: Slow response
Bernhard S #50962 03/06/15 10:04 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
Can you try if the following affects performance?
  1. Go to Tools > Preferences > User Interface / Options and disable the "Show transaction indicator in Window List" option
  2. Close the Window List
  3. Go to Tools > Preferences > User Interface / Editor and disable the "Highlight parentheses" option
Let me know if any of these steps affect performance.


Marco Kalter
Allround Automations
Re: Slow response
Marco Kalter #50966 03/06/15 12:18 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
Here my results (all options have just been tested individually):

A) With "Show transaction indicator in Window List" option enabled:
Opening Project : 1 min 10 sec => even better than v10!
Click trough all 33 windows: 1 min 00 sec => same as v10!
Close Project : 0 min 03 sec => same as v10!

B) With closed "Window List"
Opening Project : 1 min 25 sec => still a little better than v10, but not as good as v11 in A)
Click trough all 33 windows: not really possible the same way then
Close Project : 0 min 20 sec => as bad as before

C) With "Highlight parentheses" option disabled
Opening Project : 1 min 25 sec => still a little better than v10, but not as good as v11 in A)
Click trough all 33 windows: 1 min 15 sec => a bit worse than in v10 still
Close Project : 0 min 20 sec => as bad as before

So looks like the really bad guy is the option "Show transaction indicator in Window List".
With this one disabled as in A) we were back to as good or even better than v10 - in my tests at least.
It's not really a new feature, is it?
I mean PSD did that in v10 already. The feature could just not be disabled in settings then.

During all the tests I did it's not really possible to have any transaction happening. That can only be the case once you execute anything. So couldn't you eliminate transaction testing there or at least make it a lot faster so it won't bother anybody?


Regards,
Berny
Re: Slow response
Bernhard S #50968 03/06/15 02:52 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
The transaction indicator in new in 11.0. We'll check it out.


Marco Kalter
Allround Automations
Re: Slow response
Marco Kalter #50984 03/09/15 05:40 PM
Joined: Nov 2009
Posts: 74
P
Member
Offline
Member
P
Joined: Nov 2009
Posts: 74
Hi Marco. Just for info - I have same problem, new version is really slow, after Ive uncheck Show transaction indicator in Window List and Highlight parentheses its become slightly better, but there is still problem.
When Ill click on opened window in window list on right side where SQL/Output/Statistic window is I see window I expected, but it takes 3 seconds before on window list is highlighted that actuall window. No matter what kind of window - sql or command window is it.
Hope that this will hepl you to resolve this problem. Ive installed 11 today, so I have most actuall version..

Pavel

Re: Slow response
PMrb #50985 03/09/15 06:38 PM
Joined: Nov 2009
Posts: 74
P
Member
Offline
Member
P
Joined: Nov 2009
Posts: 74
And I hope that you have this as priority one bug, because using plsqldeveloper with it is really pain. Ive tried to give these highlight and show transaction parameters back, copied some commands into cmd window and whole develper frozen for few minutes till last of the commands executes. In 10 I was able to copy commands into cmd window, switch to another and work normally till cmd commands ends..

Pavel

Re: Slow response
PMrb #50986 03/09/15 07:27 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
I hope as well this is considered as a priority one bug. Even when switching off those preferences PSD v11 is really slow. I have the feeling when more instances are open that slowing it down even more too. A lot of things seem to work in slow motion really. It feels like we're running in debug mode all the time.


Regards,
Berny
Page 1 of 9 1 2 3 4 5 6 7 8 9

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.133s Queries: 16 (0.055s) Memory: 2.5689 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-29 15:26:48 UTC
Valid HTML 5 and Valid CSS