I have created an SQL statement containing a CTE. While I can get the desired result in Run SQL Scripts (ACS), it consistently takes 22 seconds to build. I'm not sure if creating an SQL view and/or suggested indexes will increase performance dramatically.
In that case, what options do I have?
I thought about having a pre-execution program that rebuilds an "output file" based on how "old" the data is (i.e. the last time it was updated). If the data is relatively new, it doesn't rebuild the file.
I could also have a button to force a rebuild and reload.
This would be replacing an old printed report that we ran from the job scheduler.
Other ideas?
In that case, what options do I have?
I thought about having a pre-execution program that rebuilds an "output file" based on how "old" the data is (i.e. the last time it was updated). If the data is relatively new, it doesn't rebuild the file.
I could also have a button to force a rebuild and reload.
This would be replacing an old printed report that we ran from the job scheduler.
Other ideas?
Comment