RE: Re: TOAD appears to "pause" before executing a query?

The parser is complete with its work prior to us sending the query to the database. Any syntax errors reported by the parser are identified by the red squiggles (if you have them enabled) or displayed in the Messages panel when performing certain actions like formatting. When executing via F9/Ctrl+Enter the parser is non-blocking. Any objections it has to your statement are ignored and the SQL is sent as it exists. After execution we query 

> ...very slow coming back and reporting invalid syntax when I execute a query.  

Does this delay only occur when the statement has a syntax error? Under normal execution where there are no errors to report Toad does the following post-processing.

1. Enable/disable SQL Trace (TKPROF) if the option has changed while the query was executing
2. Commit if autocommit is enabled
3. Gather post-execution statistics for Auto Trace feature if enabled (executes a query)
4. Retrieve DBMS Output if option is enabled to automatically poll for it following execution and if the statement contains reference to DBMS_OUTPUT.PUT[_LINE].
5. Display the value of any output parameters
6. Add the statement to SQL Recall

If there was an error during execution...

1. If error is ORA-911 and the last character of your statement is ';' then strip it and re-execute. This will only occur when you execute a selection IIRC.
2. Retrieve error offset information from our query component and display it.

Perhaps something above will trigger something. If it happens under non-error conditions did you have Auto Trace enabled or dbms_output statements with the option to poll? What about changing the current schema via the dropdown on the Editor toolbar?

Michael

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of r_squires
Sent: Monday, May 07, 2012 7:19 PM
To: [email protected]
Subject: [toad] Re: TOAD appears to "pause" before executing a query?

I can't be sure, I'm not sure if it's the first instance of a SQL Editor window, or a tab within the SQL Editor.  Sometimes it seems like going back to a query after some time I experience the same thing.  It's definitely not just the first time TOAD is loaded, I get this several times within the same instance of TOAD.

I think it's the parser, TOAD can be very slow coming back and reporting invalid syntax when I execute a query.  Could be related.

I don't use the formatter.

I also have a very underpowered machine.  Who only has 2GB of RAM nowadays!

If I ever get a reproducible scenario I'll let you know but it appears pretty random at the moment (but several times a day).  Just wondered if anyone else had noticed this.

--- In [email protected], Michael Staszewski <michael.staszewski@...> wrote:
>
> Does this occur several times per instance of Toad or is it only the first execution for an instance? The parser DLL is loaded once per Toad session the first time it is needed. I am not sure what initialization occurs during the load, but I have seen that the first time the formatter is invoked the format is slower than subsequent formats. It also uses the same DLL.
> 
> Michael
> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of r_squires
> Sent: Sunday, May 06, 2012 11:58 PM
> To: [email protected]
> Subject: [toad] TOAD appears to "pause" before executing a query?
> 
> Anyone else notice this?  I can't reproduce it consistently but quite often TOAD will appear to pause before executing a query against the database - I'm guessing it's doing some of its own parsing before issuing the command against the database.  It's small, probably about a second, but when you are expecting a sub-second response from the query TOADs overhead can be a little frustrating.
> 
> It doesn't appear to be related to the size of the query either, it's almost as if TOAD is doing some kind of initialisation.
> 
> 
> 
> ------------------------------------
> 
> Yahoo! Groups Links
>




------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/