Re: Help! Canceling an Oracle query thorugh ADO takes almost as long to run as the query itself.
Date: Fri, 19 Jul 2002 15:03:11 GMT
Message-ID: <PSVZ8.2972$i54.113932518_at_newssvr21.news.prodigy.com>
Yes, it is waiting for the first row to be retrieved. The queries are large and complex. The problem is, some queries can take 20 minutes to run but the first row wont be retrieved until 15 minutes have passed.
"Brian Peasey" <bpeasey_at_doncarsys.com> wrote in message
news:oyUZ8.10308$f05.530473_at_news1.calgary.shaw.ca...
> Hi,
>
> We have a similar experience with PowerBuilder/Oracle. Apparently the
> cancel doesn't work until the first row is retrieved. Most our SQL
> statements are not extremely large or complex. Usually the problem is from
a
> un-polished SQL statement.
>
> I don't know ADO but it is possible that your cancel may be also waiting
for
> the first row to be returned. Check your ADO help and see.
>
> Best Regards,
> Brian
>
>
>
Received on Fri Jul 19 2002 - 17:03:11 CEST