Longstanding issue: Editor tabs slow to a crawl over time

Toad for SQL Server
1

Hi,

One of the most irksome qualities of Toad is that editor tabs that remain open for long periods of time – say in a multi-day development of a gnarly sproc – become increasingly slow to the point of being unusable. This manifests itself as a marked delay between a keypress and the text showing up on the screen, and curiously the delay is worse at the top of the tab vs the bottom.

The only way around the slowness is to close the tab and open it up again, but that hardly counts as a solution. You lose carefully crafted temp tables being used for data validation, for example.

I brought this issue up once in Toad for MySQL but I’m disappointed to find it to be the case in the SQL Server version as well. Needless to say, no other SQL environment that I’ve tested (SSMS, dbForge, etc) suffers from this kind of slowdown. It is easy to reproduce in the sense that we constantly encounter the slowdown in our regular work, but it’s not deterministic in a way that’s convenient for debugging: there’s some black magic combination of a long-running tab, large amounts of code, and ceaseless editing including many iterations of commenting out code to test different portions.

It would be wonderful if this was somehow an issue with the parser (which really needs to be overhauled anyway), but I wanted to put this out there again. My requests here on and the beta forum all seem trivially small, but frankly they are simple bugs that should not appear in any production piece of software. Consequently, my recommendation that my company switch to the paid versions of Toad is starting to look quite foolish.

Best,

KJ

2

I too experience this issue, almost on a daily basis, and it is quite annoying. Everything will be working fine, then all of the sudden, things slow way down. and each keystroke takes a long time. The amount of time usually depends on how big your script is. If you have a very large script and are not in large script mode, it can be minutes between key strokes. If you type ahead 20 characters, it can be twenty minutes before TOAD comes back. This has been an issue for years, (as you can see, the original post is 6 years old), and really needs to be fixed.

Ok, here is the workaround...
After TOAD becomes responsive again:

  1. Place cursor in editor window, and CTRL-A to select everything
  2. CTRL-X to cut everything and copy it to the clipboard
  3. CTRL-V to copy everything in the clipboard back to the editor window.

TOAD should again be responsive... for a while anyway.

I hope this is helpful to someone.