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