|Subject||RE: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing? (SOLVED)|
Set you are truly an asset to this list and in my book rank at the top of the list with Helen and Mark. I have learned so much from you three in the last few months. I of course do not discount any others that send out helpful replies as I can learn from all (Trust me).
Anyway, I have modified my stored procedure to implement your suggestion:
Then I'd expect a small improvement if you generally changed to
AND PP.STATUS_CODE||'' IN ('G','V')
ORDER BY PP.STATUS_CODE||''
It went from 2 hours and 45 minutes down to … get this … under 12 minutes. WOW
Thanks so much for all that have replied.