Beautifier speed?

[Brian Hurley]

In the next version is the PLSQL beautifier going to be faster? I get sql from others in my group or sql that is outputed to logs, to fix. Without the beautifier most are hard to read. I got one today that is 664 lines long (several unions) and the beautifier just choked. It ran for over 10 minutes before I just killed it. It was using 100% CPU for that time period.

I can send you the sql if you want to test it. However, I can not publish the sql in a public forum.

Please do something to make this faster.

Thanks,
Brian

 

[Ameen]

There must be a problem smoewhere else in your computer, I have tried to beautify 580 lines, and it did it in a matter of 1 second.

 

[Brian Hurley]

Most sql works in less then 1 sec. However, I've had several that can take up to 60 seconds to beautify. The one that I referenced above I waited about 10 minutes before I killed the application. This is a bug somewhere.

BTW: I'm using v7.0.3.1123

 

[RobertK]

I have 600+ lines long XML-generating SQL (so a LOT of nestings)
and the app crashes ***everytime***.

I resort to TOAD's Formatter and it does it instantaneously

 

[Clouds]

I have experienced problems with the beautifier too...

There are some things the beautifier does not like:

- Nested CASE-statements wil have the beautifier do nothing at all, except for setting the status bar to something like 'could not parse text'.

- Multiple unions will surely KILL...try to beautify a statement with about 20 times 'select 1 from dual union all...'. It will crash PL/SQL Dev (or at least have it locked for hours)

Normally statements without CASE and/or UNION are beautified quite fast (nested SELECTs will slow it down though)...

I'd love to see the beautifier improved on points mentioned!

 

[Brian Hurley]

Sounds like a bug to me...