We Talk Coding

Do Apache+IIS tell databases that a client has closed their browser session so their query should be aborted?

I've lost count of the number of times I have closed my client browser because I requested a search I didn't need. When I do this, do popular webservers (IIS, Apache) tell popular attached database systems (like MsSQL, MySQL, Oracle) to abort the search process or does it carry on running until completion/timeout? Is this standard functionality or does it rely on the programmer writing it in to the script?

Public Comments

  1. If you're asking what I think you are asking, does the database stop executing a query if you close a connection to it (which will happen if the IIS session stops, depending on if you are using things like ODBC connection pooling, Permanent conections in PHP etc) I don't *think* it would... However, the issue is somewhat negligable because if you are running a query which takes a significant amount of time and is run every time someone makes a page request you should be looking at a new/better cache implimentation.
Powered by Yahoo! Answers