Re: Cancelling an ADO Command takes too long

first question, are you sure Oracle accepts such a command? Just
asking, it's been years since I last worked with that db... :)

I'm not sure of anything -- that's part of my problem ;-)

I would expect that Oracle, given that it is a major player, would support a
cancel command but I wouldn't be surprised if it doesn't. I know Oracle is
capable of cancelling active queries via administrative commands since
that's how most of our clients cancel runaway queries now. However, I would
like to offer a solution that doesn't require the use of a DBA. DBA's tend
to like our software more when they don't have to get involved in the
day-to-day operation.

Said this, I'm not sure if regarding updates and depending on if you do
batch updates or not, it would work as you want. Maybe CancelBatch
would be better for that. See also CancelUpdate.

The queries in question are mostly SELECT statements. When the query takes
too long (or appears to lock) it is usually because the person writing the
query didn't join two tables correctly. The server is busy spending its
time joining millions of records together for the correct result set when
the author merely wanted a few dozen. They will notice their mistake almost
immediately but by then it's too late.

Check these URLs. You will find some examples

Thanks for the reply and the links. I will see if anything there can help
me.

- Clayton


.

Relevant Pages

  • Re: Parent/Child Relationship to Integrate Data in Reports
    ... I am working on updating my queries but am confident ... On the code to cancel the before update ... Create a query joining the projects and expenses tables. ... Join ProjectID from one table to ParentProjectID in the other. ...
    (microsoft.public.access.reports)
  • Cancel query in 10g
    ... We are using forms 10g and would like to be able to cancel a query. ... Just setting the module to non-blocking, pops up the Oracle Cancel ... Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production ...
    (comp.databases.oracle.tools)
  • Create a Cancel Button to Halt an operation
    ... create a Cancel button on some form, that when clicked, ... of queries run (some are Update Queries and others are ... execution of the Query that is being run. ...
    (microsoft.public.access.formscoding)
  • Cancelling query with ADO and Oracle
    ... I am running a VB.NET application which is using ADO to connect to an Oracle ... I have a form which runs a query which can take a considerable ... The user can cancel the execution of this query at any time by ...
    (microsoft.public.dotnet.framework.adonet)
  • Cancelling an ADO query with Oracle
    ... I am running a VB.NET application which is using ADO to connect to an Oracle ... I have a form which runs a query which can take a considerable ... The user can cancel the execution of this query at any time by ...
    (microsoft.public.dotnet.general)