v13: extremely slow Command Window script execution

[Bernhard S]

I have a command window script, which just creates a user and grants a lot of object and system privileges to this user.
Executing this script in v13 is awfully slow! It takes 6 min 12 sec there to complete the script. to get from one grant to the next it takes about 3 seconds! In the status line you see that that grant itself just takes about 30 ms, most of the time is taken by "Initializing...".
If I execute the same script using v12 version, it is done in 25 seconds!
So v13 is about factor 15 slower compared to v12 here!

Another annoyance is, that you cannot even cancel execution of the script in v13, because the cancel button remains greyed out. You only get to see the cancel button when you switch to another window and come back to the PL/SQL Developer window again.

During execution of this script in v13 you can also see that one CPU is pretty much at its limits!

 

[Marco Kalter]

Can you send me an example script by e-mail?

 

[Bernhard S]

Have just sent you an example script with spooled results from execution on v13 and v12 PL/SQL-Developer version.

 

[Marco Kalter]

Thanks. The problem seems to be introduced in version 13.0 when using many connection definitions. We will send you a test fix today.

 

[Bernhard S]

The fix speeds it up again, but we are still about 50% slower than in version 12.0. I hope performance can be further tweaked so that we get back to the same speed or faster.

 

[Marco Kalter]

We'll check it out. Could it be that you still have the DebugSQL parameter in place? This will slow things down. If so, please remove it and try again.

 

[Bernhard S]

No, I made sure that I compare only performance either in both versions with DebugSQL or without, but not mixed. I have sent you some more detailed analysis as requested.

 

[Bernhard S]

The latest version of v13 that I got to test is indeed almost 3 times as fast as v12. So I hope to see the same performance soon in an official version.

 

[Marco Kalter]

This will be available in 13.0.1 shortly.

 

[Bernhard S]

That is great to know!

In order to more easily compare execution times in the future, would it be possible to add some instrumentation to show execution times for Command File execution in the status line?

I noticed also that opening and closing projects is quite a lot faster now in latest v13 fix compared to v12. I would like there to be added instrumentation as well and show the time it took to open a project. Maybe it makes also sense to calculate how long it took on average per window list item to open the current project, as I would guess projet opening should be pretty much proportional to the number of window list items.

Would it also be possible to show the progress of opening a project i.e "x of y window list items opened" and maybe a percentage? That would also be a clear indicator showing when a project is 100% open and available. Currently this is not so clear. You basically only know that it's all open, when the project item list is autohiding again.

I would also like to get shown the total time it took for closing a project.

In case any of this instrumentation adds too much overhead it makes sense to have those features optionally switched off via preferences settings.

 

[Marco Kalter]

I have added this to the list of enhancement requests.