> From what you are saying, a simple UDR has worse performance than a > simple SP, so presumably it will be significantly worse than a UDF. > > I have never compared load and call times for UDFs and SPs, but I have > always assumed that a UDF will load and execute more quickly than a SP.
I would say your assumption is not correct. Although I still haven't done the test, my expectation is that the PSQL would beat the UDF in invocation/load and UDF would be faster for execution. I would report back when I do the test, as time permits. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
