Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Query/Script running limitation |
Wed, May 5 2010 7:59 AM | Permanent Link |
durumdara | 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 |
Wed, May 5 2010 6:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << 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 |
Thu, May 6 2010 2:49 AM | Permanent Link |
durumdara | 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 |
Thu, May 6 2010 5:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |