Re: Toad can multi-thread & doesn't have to lock up during long queries !
Date: Mon, 18 Nov 2002 02:15:14 GMT
Message-ID: <S2YB9.58722$hp5.8091254_at_twister.southeast.rr.com>
It has been an option in TOAD for far longer than three versions but has always previously defaulted to FALSE because of the performance hit. My own propensity to favor performance over convenience has always dominated TOAD options and features. But I suspect that the default will be reversed in the next version.
> I learned this today at the Quest booth at OracleWorld.
>
> I was complaining to the Quest rep about how the whole Toad app
> shouldn't have to lock up during long queries & then he patiently
> showed me that there's a multi-threading / cancel option.
>
> - Go to View : Options : SQL Editor
>
> - Check "Process statements in threads / allow queries to be
> cancelled" option
>
> While long queries run a cancel button will show that will let you
> cancel the query or while you can switch out to other Toad windows.
>
> They admitted that this might be an option that they should default to
> on.
>
> Apparently this feature has been in Toad for the last 3 versions.
Received on Mon Nov 18 2002 - 03:15:14 CET