[PERFORM] Query timing increased from 3s to 55s when used as function instead of select

ota_get_staff_leave_summary(6); Time: 57375.477 ms We have tried using explain analyse to update the query optimiser, dropped and recreated the function and have restarted both the machine and the postgres server multiple times. Any help or advice would be greatly appreciated. Kindest regards,

Re: [PERFORM] Query timing increased from 3s to 55s when used as a function instead of select

As a side to that, we have the fn_medirota_validate_rota_master calls in a large amount of our other functions that are running very well. -- Tyler Hildebrandt Software Developer ty...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 020 7631 1555 3 Tottenham Street London

[PERFORM] Query timing increased from 3s to 55s when used as a function instead of select

ota_get_staff_leave_summary(6); Time: 57375.477 ms We have tried using explain analyse to update the query optimiser, dropped and recreated the function and have restarted both the machine and the postgres server multiple times. Any help or advice would be greatly appreciated. Kindest regards,