[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
Delivered-to: email@hidden
Delivered-to: email@hidden


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:
> http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%
> 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: http://lists.apple.com/mailman/options/webobjects-dev/johnthuss% 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: http://lists.apple.com/mailman/options/webobjects-dev/jgagnon% 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:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

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

Home