1. 

   adamhaeder, Member

   I have a large query that I want to display both the table results and a few charts of different parts of the data on 1 report. Is the best practice (in my stored procedure) to run the large query, save the result to a tmp table, do a select * from the tmp table for the table part of the report, and then do different selects from the tmp table to get data for the different charts? Otherwise, it seems like I have to keep rerunning my large query over and over. Just wondering what other people have done in this situation. Thanks
2. 

   myDBR Team, Key Master

   If you have the same (or essentially same), large query repeating inside a report, you may save a lot of I/O and memory in the server if you use temp tables.

   Generally speaking, if you use the temp tables wisely (do not try to store too much data or use them when you do not actually need them), they are a great asset to you.

   --
   myDBR Team

Reply

You must log in to post.