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.