pcsoft.us.windevCopyright 2026, PC SOFT8 Jul 2016 01:25:00 Z7 Jul 2016 14:57:00 ZHi, What would be the best strategy to run an long calculation that is done in a MS SQL stored Procedure triggered by a user action from a webpage ? The user presses the"Calculate" button on the webpage. This will call a procedure on the WebDev Server Side that is calling the MS SQL Stored Procedure that does the calculation. This calculation takes about 1 to 2 minutes depending on the parameters. I show a wait dialog on the screen, but my Browser (Chrome) will display an warning box that the server is not responding. You can select cancel or wait. But if it takes to long it will just abort the whole thing ! Even the warning box is not wanted. Can I start a thread on server side to run this procedure in the background ? En when it is finished, how can I notify the user ? I would like to show a "Calculating NOW" message in the browser that would disappear when the calculation is done, even if this calculation or process would take a few minutes and would exceed the browser response timeout ! How to best approach this kind of problem ? Thanks Danny30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58549-wb21-long-running-sql-query-background/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58549-wb21-long-running-sql-query-background-58558/read.awp8 Jul 2016 01:25:00 ZThanks Fabrice, I'll try that direction and post the results here ! Dannyhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58549-wb21-long-running-sql-query-background-58558/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58549-wb21-long-running-sql-query-background-58558/read.awp[WB21] Long running MS SQL Query in background ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58549-wb21-long-running-sql-query-background-58552/read.awp7 Jul 2016 16:20:00 ZHi Danny, you could use a call made with ajaxexecuteasynchronous from browser code... This call doesn't wait for a return,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58549-wb21-long-running-sql-query-background-58552/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58549-wb21-long-running-sql-query-background-58552/read.awp[WB21] Long running MS SQL Query in background ?