Dear Support!


a.)
I want to ask that have EDB some option that can limit the length of the query running time?

May I see somewhere, but possible in other DB - I'm confused because usage of many languages, and customers other dbs...

So I want to set that query is don't run more than 10 minutes, and if it is do, server terminate it.

b.)
And is exists same thing in EDBScript?
As I know good that EDBScript's script is run on server.
So there is also need some limit, if possible.

Thanks for your help:
  dd

<< I want to ask that have EDB some option that can limit the length of the
query running time?

May I see somewhere, but possible in other DB - I'm confused because usage
of many languages, and customers other dbs...

So I want to set that query is don't run more than 10 minutes, and if it is
do, server terminate it. >>

You can do this from the client application - just keep track of the time
and define an event handler for the OnProgress event that sets Continue to
False if the time is exceeded.

<< And is exists same thing in EDBScript? As I know good that EDBScript's
script is run on server.  So there is also need some limit, if possible. >>

Yes, you can do the same thing (above) with a TEDBScript.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi!

<< You can do this from the client application - just keep track of the time
and define an event handler for the OnProgress event that sets Continue to
False if the time is exceeded.
Yes, you can do the same thing (above) with a TEDBScript. >>

And what happened if a client timeout reached.
For example:
The client is started a long query, and he/she is disconnects (in this case - the client crashed).
Question:  if the server reach the X minutes, is it automatically kill the Query thread?

Or possible the long query is running all night long without the client?

Thanks!

Sincerely:
  dd

<< And what happened if a client timeout reached.
For example:
The client is started a long query, and he/she is disconnects (in this
case - the client crashed).
Question:  if the server reach the X minutes, is it automatically kill the
Query thread?

Or possible the long query is running all night long without the client? >>

If you have an OnProgress event handler defined for the query, then the
client disconnecting will cause the query to abort if it does not receive a
response back from the client session when sending a progress message to the
client session.

--
Tim Young
Elevate Software
www.elevatesoft.com