jeudi 30 novembre 2017

Cancel database queries after closing browser

I am having web application (using angular.js and devextreme) which calls some API to get data from database(Mysql). I have some long running queries for larger data set. If I close the browser or navigate to other pages, current queries getting running on database. If user navigates to different pages frequently , database having many unnecessary queries running. Is there any way so that I can track DB queries (like some query Id etc) from web app, so whenever user moves to another web pages, I can cancel current running query?

Note: I don't want to use query timeout on DB as I have some background long running queries on DB server.




Aucun commentaire:

Enregistrer un commentaire