Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! Canceling an Oracle query thorugh ADO takes almost as long to run as the query itself.
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 - 10:03:11 CDT