I have a fairly complex script (approx 2,500 lines, with several table variables, using some wide tables & views, ie 400 columns plus, and with large sections commented out)
If I have SQL Prompt 4 enabled, then scrolling up and down (using the up & down arrow keys) slows considerably - down to maybe 2 lines per second. If I type anything, then nothing appears until I pause for about a second. Selecting any text using the arrow keys is very slow. Selecting using the mouse however works normally, as does PageUp and PageDown. If I look at the Task Manager, I notice that the SqlWb.exe process takes 50% of my CPU when scrolling up or down (on a dual CPU machine).
This makes editing the script very difficult.
If I disable SQLPrompt, then scrolling returns to about 15 lines per second and typing appears immediately. CPU usage drops to 40% when scrolling down, and 15% when scrolling up.
I am using SQL Prompt Pro v220.127.116.11, SQL Server 2005 and XP Pro.