Re: Help! Canceling an Oracle query thorugh ADO takes almost as long to run as the query itself.

From: Brian Peasey <bpeasey_at_doncarsys.com>
Date: Fri, 19 Jul 2002 13:33:08 GMT
Message-ID: <oyUZ8.10308$f05.530473_at_news1.calgary.shaw.ca>

Hi,

[Quoted] 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 [Quoted] un-polished SQL statement.

I don't know ADO but it is possible that your cancel may be also waiting for [Quoted] the first row to be returned. Check your ADO help and see.

Best Regards,
Brian Received on Fri Jul 19 2002 - 15:33:08 CEST

This message: [ Message body ]
Next message: BigM: "Looping thru items in a block"
Previous message: olivier: "!!! Problem with BLOB and rwdbblob type in roguewave !!!"
In reply to: John Boe: "Help! Canceling an Oracle query thorugh ADO takes almost as long to run as the query itself."
Next in thread: Daniel Morgan: "Re: Help! Canceling an Oracle query thorugh ADO takes almost as long to run as the query itself."
Reply: John Boe: "Re: Help! Canceling an Oracle query thorugh ADO takes almost as long to run as the query itself."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message