Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

7
  • How big is the result size? I can't think of why it would be necessary to store results in a temporary table. If there is an end user paging through results, why would they have need to see any more than 15-20 items at a time? Even if the page size is hundreds or low thousands I can't see a need to store in a temporary table? Commented Apr 26, 2020 at 12:36
  • Also, can you share some snippets of the code that you have so far? It's hard to help without seeing some code. Also what frameworks are you working with? Is this an ASP.NET MVC 5 application? Or is it a ASP.NET Core? Commented Apr 26, 2020 at 12:37
  • I have added sql query which uses temporary table for example. and also I need to store result, because I don't want to change search result if there is any, during navigation. I want to preserve initial result except that user does search again. Commented Apr 26, 2020 at 12:47
  • records need to handle as large as 20-30 million. Commented Apr 26, 2020 at 12:48
  • 2
    It's a good approach to cache the results for sometime. Post that why can't you remove these tables using a cron? Commented Apr 26, 2020 at 13:25