Help with JQUERY/update status of a running query

Scriptcase 9 General
#1

Hi Guys
I need some help to update status of a running query (how many records are processed)
I guess this can be done using a jquery call to a separate app.
any one has a similar code to start with?

thanks for the sharing

Good day.

#2

Mmm…
What sort of query exactly ? If is one single sql statement without any for/while loop I dont think it easy to get any sort of percentage completion status to show on the browser with javascript/jquery. There is no provision in SQL to know the status of a query while the query is still running.

1 Like
#3

true, however it is possible cause every query has a sessionid and is split into 150 records per sql insert batch. i count how many records were already inserted. i am doing it with Azure data studio. (as u noticed, the counter goes with 150 records increment)
the only problem now to run the record count from PHP and update a data loading form with the results.

if a user loads a CSV file with 50K records, it can take 2minutes. not really user friendly if no progress is reported.