• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Interrupting a fetch that is taking too long
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Interrupting a fetch that is taking too long


  • Subject: Re: Interrupting a fetch that is taking too long
  • From: Jacky Gagnon <email@hidden>
  • Date: Wed, 16 May 2007 10:29:24 -0400


On 07-05-15, at 18:04, John Huss wrote:

Well, I'm completely guessing, but here's an idea.

Wonder has a facility to log queries that run longer than X.  Perhaps
you can tap into this to take an action.

Its easy to calculate this without Wonder if you need to. You just have to use the "EOAdaptorChannel.Delegate"; you take the start time in "adaptorChannelShouldEvaluateExpression" and you calculate how much time take your request in "adaptorChannelDidEvaluateExpression".




Actually terminating a query in progress is database-specific, so there is no EOF way to do it. I know Frontbase allows you to terminate connections and such from the GUI (under the Usage tab), but I don't know if you can do this programmatically. I would suggest contacting your db vendor and asking.

John

On 5/15/07, Kieran Kelleher <email@hidden> wrote:
Just assume a long response for all queries. if finished in 1 second,
then the page will be back in one second, if not it will take how
ever long it takes.

On May 15, 2007, at 4:34 PM, Ricardo Parada wrote:

> Hi All,
>
> Let's say I have a GUI that lets users build queries to be used for
> a report.   Then another process generates a report by applying
> this user defined query.  However, if the query takes too long I
> would like to interrupt the query and then flag query for special
> handling.
>
> Has anybody figured out a way to interrupt a fetch in EOF?
>
> Thanks,
> Ricardo J. Parada
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> 40mac.com
>
> This email sent to email@hidden

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com


This email sent to email@hidden

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40druide.com


This email sent to email@hidden

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Interrupting a fetch that is taking too long (From: Ricardo Parada <email@hidden>)
 >Re: Interrupting a fetch that is taking too long (From: Kieran Kelleher <email@hidden>)
 >Re: Interrupting a fetch that is taking too long (From: "John Huss" <email@hidden>)

  • Prev by Date: Re: Interrupting a fetch that is taking too long
  • Next by Date: Deleting objects causes OutOfMemory...
  • Previous by thread: Re: Interrupting a fetch that is taking too long
  • Next by thread: Re: Interrupting a fetch that is taking too long
  • Index(es):
    • Date
    • Thread