Re: [Firebird-devel] Fwd: [Firebird-checkins] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

[Alex Peshkoff]

On 11/11/16 19:56, Vlad Khorsun wrote:
> 11.11.2016 17:20, Alex Peshkoff wrote:
>> Decimal floating point numbers - first draft
> Great !
>
>> This is according to FB4 roadmap - enhancement of precision of
>> calculations in firebird.
>> You can read about decfloat datatype here:
>> https://www.toadworld.com/platforms/ibmdb2/w/wiki/7700.decfloat-overview
>> IBM's library decNumber (has ICU license)
>> http://speleotrove.com/decimal/decnumber.html is used in out implementation.
>>
>> What's done:
>> - Added new datatypes: DECFLOAT(16) and DECFLOAT(34), using 64/128 bits
>> for numbers representation.
>> - It can be used in all calculations, including various aggregates,
>> power and logarithm,  but missing trigonometry.
>> - DecFloats are supported in network protocol.
>>
>> What's missing:
>> - Use of decimal float in sort operations
> Also, it can't be indexed so far, correct ?

Certainly.


--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] (CORE-4563): Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality

[Vlad Khorsun]

11.11.2016 11:06, Karsten Strobel wrote:
> Hi Firebird Developers!
>
>
>
> I access Firebird frequently from Windows services running on the same 
> machine. I have a huge number of accesses each with small
> impact, many updates and inserts rather than selects. Roundtrip time is very 
> critical. I’m using the Firebird ADO.NET driver, thus
> doing localhost/loopback TCP communication.
>
>
>
> Compared to MS SQL, Firdbird’s localhost TCP roundtrips from Client to Server 
> for doing things like single-row inserts or updates
> take significantly longer. There may be a several reasons for this. One 
> simple improvement would be to switch the
> SIO_LOOPBACK_FAST_PATH socket option ON on the Windows platform.
>
>
>
> A request has already been file here 
> http://tracker.firebirdsql.org/browse/CORE-4563 but it’s tagged as minor 
> priority, so will
> probably not get addressed soon.

   I looked few times at this ticket and it seems there should be no problems 
to add SIO_LOOPBACK_FAST_PATH
socket option but i have no win8 box to test it.


> What I can say is that implementing this could cause a significant 
> performance gain at rather little effort. With other loopback TCP
> communications in my own applications I realized a 20+ % improvement in 
> transporting data packets.
>
>
>
> I’d suggest to define a new firebird.config setting (default off), to reduce 
> the risk. I could provide code for the Firebird ADO.NET
> driver side and, if someone could point me to the right direction, I would 
> also prepare a change in the Firebird C++ code to set
> this option. (However currently I don’t have the tools to compile Firebird.)

   I can make necessary changes at Firebird side and provide special build. 
Could you build
.Net driver with SIO_LOOPBACK_FAST_PATH and test performance ?

> What I’d love to see is this feature in the next 2.5.x release (and in 3.0 as 
> well, of course, but currently we’re still with 2.5).

   No promise for 2.5.7. If there will be notable performance gain - it could 
be an argument :)

Regards,
Vlad

PS Feel free to contact me directly, if needed

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] (CORE-4563): Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality

[Leyne, Sean]

> 11.11.2016 10:06, Karsten Strobel wrote:
> > Compared to MS SQL, Firdbird's localhost TCP roundtrips from Client to
> > Server for doing things like single-row inserts or updates take
> > significantly longer. There may be a several reasons for this.
> 
>The most viable one that MS SQL uses shared memory for talking with local
> server, not TCP. You could use it as well with Firebird 3.0 using xnet:// 
> prefix
> to force XNET protocol. Though I don't know if .NET provider supports that.

There are plenty of use cases where xnet may not be the desired protocol.

The new Windows API would actually improve performance for applications on the 
db host used TCP, where the IP address used in the connection was that of the 
host itself (ie. The improvement does not depend on the use of 127.0.0.1 as the 
IP address).


>If you care about performance, perhaps you'd better to abandon .NET and
> switch to native code.

This type of comment has no place in discussion regarding bugs or feature 
requests.  There are plenty examples of .Net code which out perform C/C++ code.


Sean


--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird3 build fails on MacOsX

[marius adrian popa]

Thank you , it would be nice a solution without turning off SIP

On Fri, Nov 11, 2016 at 12:47 PM, Paul Beach  wrote:

>
> < http://nabble.documentfoundation.org/Firebird-build-fails-on-MacOs-
> tdf-101789-td4199396.html>>
>
> http://paulbeachsblog.blogspot.fr/2016/03/dyldlibrarypath-and-el-
> capitan.html
>
> Regards
> Paul
>
> 
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphiFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Node.js Firebird API

[marius adrian popa]

Nodejs api based on FB3 OO api

https://asfernandes.github.io/2016/10/20/node-firebird-api.html
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphiFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] (CORE-4563): Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality

[Karsten Strobel]

Dimitry Sibiryakov wrote:

>   The most viable one that MS SQL uses shared memory for talking with local 
> server, not 
> TCP. You could use it as well with Firebird 3.0 using xnet:// prefix to force 
> XNET 
> protocol. Though I don't know if .NET provider supports that.
>   If you care about performance, perhaps you'd better to abandon .NET and 
> switch to 
> native code.

Abandoning .NET if surely no option for me. Our entire product is based on .NET 
and uses Entity Framework. Changing this is impossible (and undesired).

Unfortunately the Firebird ADO.NET driver doesn't support the xnet protocol to 
a local FB server. Enabling the Loopback Fast Path option is a few lines of 
code only (both on client and server side), compared to implementing xnet in 
ADO.NET that's very little effort.

Karsten

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fwd: [Firebird-checkins] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

[Vlad Khorsun]

11.11.2016 17:20, Alex Peshkoff wrote:
> Decimal floating point numbers - first draft

   Great !

> This is according to FB4 roadmap - enhancement of precision of
> calculations in firebird.
> You can read about decfloat datatype here:
> https://www.toadworld.com/platforms/ibmdb2/w/wiki/7700.decfloat-overview
> IBM's library decNumber (has ICU license)
> http://speleotrove.com/decimal/decnumber.html is used in out implementation.
>
> What's done:
> - Added new datatypes: DECFLOAT(16) and DECFLOAT(34), using 64/128 bits
> for numbers representation.
> - It can be used in all calculations, including various aggregates,
> power and logarithm,  but missing trigonometry.
> - DecFloats are supported in network protocol.
>
> What's missing:
> - Use of decimal float in sort operations

   Also, it can't be indexed so far, correct ?

> - Control over rounding modes and exception raise rules (low-level
> support is included).

Regards,
Vlad


--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fwd: [Firebird-checkins] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

[Dimitry Sibiryakov]

11.11.2016 16:20, Alex Peshkoff wrote:
> What's done:
> - Added new datatypes: DECFLOAT(16) and DECFLOAT(34), using 64/128 bits
> for numbers representation.

   What is the point of these new types? Cannot you just expand list of 
back-end storage 
for standard DECIMAL?


-- 
   WBR, SD.

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Fwd: [Firebird-checkins] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

[Alex Peshkoff]

Decimal floating point numbers - first draft

This is according to FB4 roadmap - enhancement of precision of 
calculations in firebird.
You can read about decfloat datatype here: 
https://www.toadworld.com/platforms/ibmdb2/w/wiki/7700.decfloat-overview
IBM's library decNumber (has ICU license) 
http://speleotrove.com/decimal/decnumber.html is used in out implementation.

What's done:
- Added new datatypes: DECFLOAT(16) and DECFLOAT(34), using 64/128 bits 
for numbers representation.
- It can be used in all calculations, including various aggregates, 
power and logarithm,  but missing trigonometry.
- DecFloats are supported in network protocol.

What's missing:
- Use of decimal float in sort operations
- Control over rounding modes and exception raise rules (low-level 
support is included).



--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird3 build fails on MacOsX

[Paul Beach]

>

http://paulbeachsblog.blogspot.fr/2016/03/dyldlibrarypath-and-el-capitan.html

Regards
Paul

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird3 build fails on MacOsX

[Stephan Bergmann]

On 11/11/2016 11:22 AM, marius adrian popa wrote:
> Discussion on LibreOffice dev list
>
> http://nabble.documentfoundation.org/Firebird-build-fails-on-MacOs-tdf-101789-td4199396.html

Relevant LibreOffice patch is 

 
"Allow external/firebird to be built with a custom SHELL under Mac OS X 
10.11" (plus 

 
"Revive external/firebird/macosx-elcapitan-dyld.patch" adapting it to 
Firebird 3 version of examples/empbuild/empbuild.e).

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] (CORE-4563): Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality

[Dimitry Sibiryakov]

11.11.2016 10:06, Karsten Strobel wrote:
> Compared to MS SQL, Firdbird’s localhost TCP roundtrips from Client to Server 
> for doing
> things like single-row inserts or updates take significantly longer. There 
> may be a
> several reasons for this.

   The most viable one that MS SQL uses shared memory for talking with local 
server, not 
TCP. You could use it as well with Firebird 3.0 using xnet:// prefix to force 
XNET 
protocol. Though I don't know if .NET provider supports that.
   If you care about performance, perhaps you'd better to abandon .NET and 
switch to 
native code.


-- 
   WBR, SD.

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] (CORE-4563): Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality

[Karsten Strobel]

Hi Firebird Developers!

I access Firebird frequently from Windows services running on the same machine. 
I have a huge number of accesses each with small impact, many updates and 
inserts rather than selects. Roundtrip time is very critical. I'm using the 
Firebird ADO.NET driver, thus doing localhost/loopback TCP communication.

Compared to MS SQL, Firdbird's localhost TCP roundtrips from Client to Server 
for doing things like single-row inserts or updates take significantly longer. 
There may be a several reasons for this. One simple improvement would be to 
switch the SIO_LOOPBACK_FAST_PATH socket option ON on the Windows platform.

A request has already been file here 
http://tracker.firebirdsql.org/browse/CORE-4563 but it's tagged as minor 
priority, so will probably not get addressed soon.

What I can say is that implementing this could cause a significant performance 
gain at rather little effort. With other loopback TCP communications in my own 
applications I realized a 20+ % improvement in transporting data packets.

I'd suggest to define a new firebird.config setting (default off), to reduce 
the risk. I could provide code for the Firebird ADO.NET driver side and, if 
someone could point me to the right direction, I would also prepare a change in 
the Firebird C++ code to set this option. (However currently I don't have the 
tools to compile Firebird.)

What I'd love to see is this feature in the next 2.5.x release (and in 3.0 as 
well, of course, but currently we're still with 2.5).

Karsten
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphiFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel