Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2006-06-29 : 08:55:11
|
| I'm following a thread in another forum where a user is asking if aborting an Ajax request will have any cancellation effect on the in-progress SQL query.I have no idea myself. But it raised another question I'd never asked or had answered:If a browser is loading a page which involves a long SQL query, (e.g., 45 seconds), if the user does any of: - hitting the browser stop button - moving to another URL - exits the browserDoes the SQL query receive an abort?Backing up a step from SQL, is the server side scripting language which issued the SQL request given any notice in this event?Sam |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-06-29 : 09:10:42
|
AFAIK a request posted to the server gets exeuted there if the whole request has been sent.If it was then the client can be closed/redirected with no problem.i have no idea about ajax cancelation.Go with the flow & have fun! Else fight the flow  |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-06-29 : 09:34:04
|
quote:
Originally posted by spirit1
AFAIK a request posted to the server gets exeuted there if the whole request has been sent.If it was then the client can be closed/redirected with no problem.i have no idea about ajax cancelation.
OK, but let's take it back. Does a browser let the server (IIS) know when a user clicks "stop"?Sam |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-06-29 : 10:19:04
|
| When you press Stop it simply kills the TCP connection.because HTTP is a connectionless protocol, there is no assurance that the web server would be made aware of this. Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
Browser abort / does the SQL query stop?