I have a form with a button that links to an app. The app loads records into a mysql table and then kicks off about 7 stored procedures one after the other. During these stored procedures, a line describing where it is “IN SP ABC DOING THIS OR THAT” goes into a PROGRESS table. I have a dashboard with the form and also with a grid of the Progress table. The grid is set to refresh every 10 seconds. When I click the button on the form to start the process, it actually shows a processing wheel and I can see the refresh happening on the grid but the grid does not show ANY update until the SPs have all run. Is there ANY WAY (I’ve tried tabs also) to get that PROGRESS table to show while the other is running or is this strictly a one at a time thing? I even tried making the grid a different connection and that doesn’t work either. I’ve GOT to have some feedback on this process. Thoughts?
Maybe a COMMIT in stored procedure process after inserting info in progress table?
But depending on DB in use.
No…it’s autocommit anyway and it doesn’t affect a thing in scriptcase. Scriptcase seems to lock out all other processes (it may be php and not scriptcase) so even I open another menu item while the processing is going on, it does not display until the process is done. Surely there is a way to give visual feedback on a long-running process!!!
Alternatively you can isolate script execution in another php script and launch it in background using what described in this sample
PHP Background
Interesting. Will experiment with both. Thanks