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 PSQL. > I just restor

[Firebird-devel] Underlying format of high precision numerics

2019-06-21 Thread Alex Peshkoff via Firebird-devel
I've compared various possible implementations of high precision numeric. Except existing in fb4 (decfloat based) were checked native gcc's __int128 and ttmath (fixed high precision library with pure .h implementation). Test performed a mix of sum/mult/div operations in a loop. Native code was

Re: [Firebird-devel] Underlying format of high precision numerics

2019-06-21 Thread Mark Rotteveel
Is this about the format used in Firebird internally, or are you also proposing to change the format used in the protocol? Mark On 21-6-2019 15:53, Alex Peshkoff via Firebird-devel wrote: I've compared various possible implementations of high precision numeric. Except existing in fb4 (decfloat

Re: [Firebird-devel] Underlying format of high precision numerics

2019-06-21 Thread Alex Peshkoff via Firebird-devel
On 21.06.2019 18:15, Mark Rotteveel wrote: Is this about the format used in Firebird internally, or are you also proposing to change the format used in the protocol? Both. Mark On 21-6-2019 15:53, Alex Peshkoff via Firebird-devel wrote: I've compared various possible implementations of high

Re: [Firebird-devel] Underlying format of high precision numerics

2019-06-21 Thread Mark Rotteveel
On 21-6-2019 17:20, Alex Peshkoff via Firebird-devel wrote: On 21.06.2019 18:15, Mark Rotteveel wrote: Is this about the format used in Firebird internally, or are you also proposing to change the format used in the protocol? Both. And we're only talking about NUMERIC/DECIMAL, not about DECF