Toad World® Forums

SQL Recall degradation popup

I just got the popup and was wondering, first - do I really need to worry about the number of sql recall statements, and secondly - if it is a potential performance issue, are there any plans to allow some sort of auto-purge? I realize I can uncheck the “warn of degraded performance” option, but I assume it’s there for a good reason.

You can let it accumulate statements. If you notice any slowdown of the SQL Recall GUI then just clean them up. The warning message is shown when the load time reaches a certain threshold. Reinstating the old option to limit to N statements is the easiest and safest solution; however, some releases back the ability to import statements was added and that feature and the total statement limit do not play well together. For the average user this is most likely not an issue. I’ll discuss with others tomorrow about how best to handle this since the warning can give the wrong impression.

From: droeschley_109 [mailto:bounce-droeschley_109@toadworld.com]

Sent: Tuesday, September 22, 2015 3:21 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] SQL Recall degradation popup

SQL Recall degradation popup

Thread created by droeschley_109

I just got the popup and was wondering, first - do I really need to worry about the number of sql recall statements, and secondly - if it is a potential performance issue, are there any plans to allow some sort of auto-purge? I realize I can uncheck the “warn of degraded performance” option, but I assume it’s there for a good reason.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

The degradation message has degraded. The options from prior versions to limit to N statements and optionally apply that limit on a per-connection basis have been restored and will be in 12.8 GA. The import statements edge case I was trying to get around is of no real concern.

Michael

On 09/22/2015 03:21 PM, droeschley_109 wrote:

SQL Recall degradation popup

Thread created by droeschley_109
I just got the popup and was wondering, first - do I really need to worry about the number of sql recall statements, and secondly - if it is a potential performance issue, are there any plans to allow some sort of auto-purge? I realize I can uncheck the “warn of degraded performance” option, but I assume it’s there for a good reason.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.