On Mon, 17 Jun 2019 11:35:11 +0200 Jiří Činčura <j...@cincura.net> wrote:
> > Perhaps the real comparison should be between UDR and UDF. > > I don't see what that would tell me. Except for the number itself. > Something particular you're looking for? > The plan is to deprecate UDFs in Firebird 4 and replace them with UDRs. So for me the question is whether a UDR is efficient enough to do that. 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. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel