what are the various methods of calling a long running SQL query and getting results?

I have a website that lets the user create custom queries. Some of the queries take a while to come back as the dynamic query can be complex. I came up with a solution to gather the user’s parameters, save them, run a periodic task on the server to process the query server side and then inform the user by email when the results are ready.

But I have a feeling there are other solutions to this type of problem.

Environment. C# .net 2013 and possibly higher SDK available. Microsoft IIS. Microsoft SQL.

submitted by /u/Matrixneo42
[link] [comments]

Leave a Reply