RE: TOAD appears to "pause" before executing a query?
Michael Staszewski <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <6548C9485A5E9C41AE3BB626E669B54710291081@ALVMBXW01.prod.quest.corp> |
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 <*> 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/