On Thu, 20 Jun 2019 13:57:56 -0000 (UTC), Virgo Pärna via Firebird-devel <firebird-devel@lists.sourceforge.net> 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 PSQL. >
I just restored database to Firebird 3. It seems, that FB3 is faster, but it might be, because it is fresh restore. In 2.5: UDF: 25 sec selectable SP (PSQL): 50 sec In 30: UDF: 20 sec selectable SP (PSQL): 30 sec PSQL function: 30 sec It is basically big query, where function is used for checking every record for 1263597 records. -- Virgo Pärna virgo.pa...@mail.ee Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
