I am evaluating PL/SQL Developer and find it an indispensable tool. Simply awesome. I am going to buy a personal copy and my client will by licenses for all the developers on the project.
That said, I find a few areas that could use improvement:
1. I find it very annoying that when I type some characters in a large package (1100 lines declaring mostly constants) and pause for about a second, the application freezes for about 3 to 4 seconds (Task Manager CPU goes 100%, WindowxXP Pro, 1.3GHz CPU, 756MB RAM).
This also happens every time I switch from package body tab to the package tab in the editor even when nothing has been typed.
The delay is very annoying and gets in the way of using the tool for extensive edits on large packages. A real shame because every other feature screams in its support.
Is there anything I can turn off in preferences that would eliminate this delay?
If not, then is there anything that can be done in a future release to move the action causing the delay into the background so that it does not to lock the application?
Even temporarily suspending the action so extensive editing can be performed without freezing would be a welcome solution.
2. Similarly, when re-compiling all invalid objects (Tools/Compile Invalid Objects ...), everything feezes until the compilation is done. The progress bar is not updated until the process is finished. When I tried this on more that 1600 objects I had no way of telling how far along the process was or if it hung completely. I had to use a new instance of PLSD and monitor the SQL tab under the session that was recompiling to catch the names of the objects being recompiled.
3. When trying to run profiling on a database that did not have profiling setup the dialog does inform of what script to run. It would be nice if it also offered to automatically run the necessary script eliminating the need to file hunt and run manually. This is done by RapidSQL and although minor would be very convenient.
Overall, awesome tool at a great price. What you guys have created beats tools 10x the price, hands down.
------------------
Vladimir Schneider
That said, I find a few areas that could use improvement:
1. I find it very annoying that when I type some characters in a large package (1100 lines declaring mostly constants) and pause for about a second, the application freezes for about 3 to 4 seconds (Task Manager CPU goes 100%, WindowxXP Pro, 1.3GHz CPU, 756MB RAM).
This also happens every time I switch from package body tab to the package tab in the editor even when nothing has been typed.
The delay is very annoying and gets in the way of using the tool for extensive edits on large packages. A real shame because every other feature screams in its support.
Is there anything I can turn off in preferences that would eliminate this delay?
If not, then is there anything that can be done in a future release to move the action causing the delay into the background so that it does not to lock the application?
Even temporarily suspending the action so extensive editing can be performed without freezing would be a welcome solution.
2. Similarly, when re-compiling all invalid objects (Tools/Compile Invalid Objects ...), everything feezes until the compilation is done. The progress bar is not updated until the process is finished. When I tried this on more that 1600 objects I had no way of telling how far along the process was or if it hung completely. I had to use a new instance of PLSD and monitor the SQL tab under the session that was recompiling to catch the names of the objects being recompiled.
3. When trying to run profiling on a database that did not have profiling setup the dialog does inform of what script to run. It would be nice if it also offered to automatically run the necessary script eliminating the need to file hunt and run manually. This is done by RapidSQL and although minor would be very convenient.
Overall, awesome tool at a great price. What you guys have created beats tools 10x the price, hands down.
------------------
Vladimir Schneider