gsr
10/04/2022, 11:00 PMexec sp_proclist
so trying to make it work in the function so i can pass thatquery to the function and it fetches that many records, not sure it will work that or i need to modify my reports because the reports are quite quite big and too many to count
Here is my trying on github
https://trycf.com/gist/2dde579d38157ccf83019557ea62a742/lucee5?theme=monokaipaul
10/04/2022, 11:20 PMgsr
10/04/2022, 11:26 PMpaul
10/04/2022, 11:37 PMEvil Ware
10/05/2022, 1:22 AMAdam Cameron
But we have many many spx and reports so doing those modifications is very tedious taskTwo thoughts on this: 1. It's quite possible to think about this vertically rather than horizontally. I suspect there is one proc that is giving you an issue currently. Fix that one. Use it as a testing ground to hone your solution. When another proc becomes a performance issue, then fix that one. Address each proc separately as you need to, rather than thinking "this perceived problem applies to all procs, so I need to fix them all now". Some procs might never become an issue, so it would not be a good usage of your time to update them unnecessarily. 2. Suck it up. Quite often our work is tedious. If you want excitement: yer in the wrong job. The object of the exercise is to deliver the correct solution, and fetching more data than you need from the DB and then trimming it off afterwards is not the correct solution here.
Adam Cameron
gsr
10/05/2022, 10:58 AMAdam Cameron
paul
10/05/2022, 4:54 PMgsr
10/05/2022, 6:00 PMEvil Ware
10/05/2022, 6:14 PMgsr
10/05/2022, 7:39 PMpaul
10/05/2022, 10:37 PM