This topic is locked
[SOLVED]

SQL Azure advice on asynchronous stored procedures

11/10/2021 10:15:31 AM
PHPRunner General questions
Dalkeith author

More of a SQL Azure question really.

Anyone got any advice on calling stored procedures in SQL Azure managed instance from PHP Runner?

Dalkeith author 11/10/2021

Sorry that should be specifically calling a procedure in an ASYNCHRONOUS way such that php runner is not frozen waiting for a long running query set.

Sergey Kornilov admin 11/10/2021

The typical approach for a long running processes is to execute them behind the scene, via AJAX request. Luckily, this is exactly how buttons work. If you add your stored procedure code to button's Server event the UI will not be frozen and users can continue doing something else.

Dalkeith author 11/11/2021

Thank you xline.