In v12.12 the SQL Recall window is slow to appear and re-appear, when unpinned and showing a full list of statements.
This doesn't happen in 12.11 or earlier, but is seen in v12.12 and v13.
It opens normally if the output is grouped (no statements are visible, only the group header), but it is slow to open and close when the grouping is set to 'none' and the SQL statements are shown directly in the list.
If any SQL is actually shown it is very slow to open and close. If only the groups are shown (collapsed) then it operates normally. If any of the groups are expanded then it is back to being slow. Not only is the opening and closing slow, but the scrolling is also slow.
To replicate, open SQL Recall in the Editor (F8) and then choose 'Group by' in the small dropdown for the options.
Also remove the filter to show all the statements.
When you unpin the window, it is slow to open/close when moving the mouse over the window.
If you have grouping enabled from a previous installation, it may also be slow.
WORKAROUND 1:
Go to the View menu | Toad Options | Windows | Uncheck 'Scroll pinned windows at [x] millisecs'.
WORKAROUND 2:
If you have grouping enabled from a previous installation and encounter the issue, reset the filter to a new grouping and now any grouping is improved. The hiding of the SQL Recall is still slow, but the speed of showing of the hidden recall window is normal once more.
If you've opened up a sub-group (such as a schema), close it before you let it hide, or it becomes slow again.
WORKAROUND 3:
Grouping the statements prevents the issue.
WORKAROUND 4:
Collapse any less frequently used categories (down pointing arrow next to category name), as the more un-collapsed categories seems to cause additional slowness.
WORKAROUND 5:
Increase the number of 'SQL Display Lines' by right-clicking an entry | 'SQL Display Lines' | click 'Show More'. If you are currently set to 1 line only, increasing it to 3 or 4 lines has showed good improvements in speed.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center