Hi,
I created a web app. I want to add a function in a form to send the query to another solution and run this query in the background because the query will retrieve more than 100,000 records, which is going to take long time. After the query is done then export the data to a file. Users still can do other things while the query is running. Is it possible?
Multiple users might send different query at the same time. My understanding is when users call this solution, they will get a instance of this solution so the queries won't be in conflict, right?
Or someone has other idea to run query in the background?
Thanks,