I find that the UI locks up when running long operations like Project Make/build with many SQL command script files (100+ files containing 1000+ functions) or recompiling invalid objects with 250+. When I have to recompile 1834 (the number in my project) the only way to get progress status is to open another PLSD and monitor the SQL for the session, catching the function names.
What happens seems to be a bug. Run a long recompile and progress moves the list updates, however dare click on a scroll bar and the whole UI locks up until the operation is finished. Progress is disabled, the title bar does not update.
Sometimes it happens by accident, mouse click somewhere outside the dialog for Make and you are toast. Even cancelling has to be done carefully. Too many clicks on the cancel and PLSD locks up until it is done.
I've resorted to killing PLSD via TaskManager and restarting. It is faster than trying to stop a runaway build or make that I no longer want. PLSD does not stop on errors generated in the command script. Only in individual objects. (Functions/Procedures/Triggers/Packages/ etc.) I cannot break up the files yet. This code is generated by an automated tool. So for now I must live with it.
Very frustrating. If its other features were not so wonderful this would be a coffin nail. But alas I've grown to love it so I am hoping for a fix.
What happens seems to be a bug. Run a long recompile and progress moves the list updates, however dare click on a scroll bar and the whole UI locks up until the operation is finished. Progress is disabled, the title bar does not update.
Sometimes it happens by accident, mouse click somewhere outside the dialog for Make and you are toast. Even cancelling has to be done carefully. Too many clicks on the cancel and PLSD locks up until it is done.
I've resorted to killing PLSD via TaskManager and restarting. It is faster than trying to stop a runaway build or make that I no longer want. PLSD does not stop on errors generated in the command script. Only in individual objects. (Functions/Procedures/Triggers/Packages/ etc.) I cannot break up the files yet. This code is generated by an automated tool. So for now I must live with it.
Very frustrating. If its other features were not so wonderful this would be a coffin nail. But alas I've grown to love it so I am hoping for a fix.
