Re: [Firebird-devel] Deprecations

2021-05-28 Thread Virgo Pärna via Firebird-devel
On Thu, 27 May 2021 08:39:58 -0300, Adriano dos Santos Fernandes wrote: > On 27/05/2021 04:29, Virgo Pärna via Firebird-devel wrote: >> >> At same time UDF is still faster than UDR/function. I did some > > UDR will always be slower than UDF, after all UDF is insecure

Re: [Firebird-devel] Deprecations

2021-05-27 Thread Virgo Pärna via Firebird-devel
On Thu, 20 May 2021 11:45:22 +, Omacht András wrote: > UDF has been a compromise for us from the beginning (since IB 6.0 or maybe > 5.5). If it is possible, we don’t want to depend on things outside of the > database because it is only a problem to have to ask the customers for any > extra

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

2020-02-27 Thread Virgo Pärna via Firebird-devel
What is actual definition of the UDF function? -- Virgo Pärna virgo.pa...@mail.ee Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] UDR vs PSQL

2019-06-21 Thread Virgo Pärna via Firebird-devel
On Thu, 20 Jun 2019 13:57:56 - (UTC), Virgo Pärna via Firebird-devel wrote: > > I once tried to rewrite one of my UDF functions as PSQL (in > Firebird 2.5.8) and it was much slower. It could be, that it was because > EXTRACT is slow and may not apply to some other PSQ

Re: [Firebird-devel] UDR vs PSQL

2019-06-20 Thread Virgo Pärna via Firebird-devel
On Wed, 19 Jun 2019 20:41:29 +0200, Jiří Činčura wrote: > 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 once tried to rewrite one of m