Re: [Firebird-devel] Profiling Windows native process?

2016-11-13 Thread Roman Simakov
2016-11-14 10:21 GMT+03:00 Thomas Steinmaurer : > do you have any recommendations what toolset to use when it comes to > profiling a Windows native process resp. Firebird 3.0.1 in particular? I worked with Windows profilers several years ago, but AMD profiler was not so bad. At least it's free and

[Firebird-devel] Profiling Windows native process?

2016-11-13 Thread Thomas Steinmaurer
Hello, do you have any recommendations what toolset to use when it comes to profiling a Windows native process resp. Firebird 3.0.1 in particular? Basically I intend to see where time is spent (or perhaps it is a sync contention) when running a loadtest against Firebird 3.0.1 SS 64-bit on Wind

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

2016-11-13 Thread Adriano dos Santos Fernandes
Em 13/11/2016 14:40, Dmitry Yemanov escreveu: > 13.11.2016 19:18, Alex Peshkoff wrote: FYI, previous problem with all Alex messages coming to my gmail spam folder I resolved putting his contact in a "white list". But now messages from Alex (even the github commits) does not enter in my mail box e

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

2016-11-13 Thread Vlad Khorsun
13.11.2016 17:06, Dmitry Yemanov wrote: > 11.11.2016 18:26, Dimitry Sibiryakov wrote: > >>> - 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

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

2016-11-13 Thread Alex Peshkoff
On 11/13/16 19:40, Dmitry Yemanov wrote: > 13.11.2016 19:18, Alex Peshkoff wrote: >> SQL> SELECT * FROM TESTDECFLOAT; >> >> FEE_DECFLOAT FEE_REAL PERCENTAGE >> == >> 0.70 0.6999

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

2016-11-13 Thread Dimitry Sibiryakov
13.11.2016 17:40, Dmitry Yemanov wrote: > I do see the difference with REAL but I'm asking for a difference with > NUMERIC backed by int32/int64. Most of compilers nowadays support int128 as well directly or via intrinsic. I would guess that to expand current arithmetic to int128 is simpler t

Re: [Firebird-devel] Support for schemas/namespaces

2016-11-13 Thread Dmitry Yemanov
13.11.2016 19:14, Fabiano Bonin wrote: > > Today I took a look at Firebird Planning Board, and didn't see a single > mention for schemas/namespaces in the plan. Planning board is about FB4 only. Schemas are likely to be implemented after that. Dmitry --

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

2016-11-13 Thread Dmitry Yemanov
13.11.2016 19:18, Alex Peshkoff wrote: > > SQL> SELECT * FROM TESTDECFLOAT; > > FEE_DECFLOAT FEE_REAL PERCENTAGE > == > 0.70 0.6999 0.05 I do see the diff

[Firebird-devel] Support for schemas/namespaces

2016-11-13 Thread Fabiano Bonin
Hi, guys! I use, contribute (monthly donation) and follow firebird development for a long, long time (almost 20 years). I really like this database, and actually I don't have a single complaint about its implemented features. But from about 2-3 years I have being chosing PostgreSQL for all new pro

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

2016-11-13 Thread Alex Peshkoff
On 11/13/16 18:06, Dmitry Yemanov wrote: > 11.11.2016 18:26, Dimitry Sibiryakov wrote: > >>> - 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 st

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

2016-11-13 Thread Dmitry Yemanov
11.11.2016 18:26, Dimitry Sibiryakov wrote: >> - 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? This is my concern too. What i

Re: [Firebird-devel] new API IMetadataBuilder Bigint[1:100]

2016-11-13 Thread Jiří Činčura
> Why? Arrays support is a secondary superstructure over the blobs, > interpreting SDL in order to extract a part of blob before sending it to > client. May be sometimes before in epoch of low speed modems that could > make sense. Today in most array uses it will be much more efficient to > sen

Re: [Firebird-devel] new API IMetadataBuilder Bigint[1:100]

2016-11-13 Thread Alex Peshkoff
On 11/13/16 14:05, Dimitry Sibiryakov wrote: > 13.11.2016 11:50, Adriano dos Santos Fernandes wrote: >> Old API is a client of the new API > Yes, I know. I took part in it if you forget. > >> so you're totally wrong. > Feel free to provide a better answer if you can. Can you?.. > > New API

Re: [Firebird-devel] new API IMetadataBuilder Bigint[1:100]

2016-11-13 Thread Dimitry Sibiryakov
13.11.2016 11:50, Adriano dos Santos Fernandes wrote: > Old API is a client of the new API Yes, I know. I took part in it if you forget. > so you're totally wrong. Feel free to provide a better answer if you can. Can you?.. -- WBR, SD. ---

Re: [Firebird-devel] new API IMetadataBuilder Bigint[1:100]

2016-11-13 Thread Adriano dos Santos Fernandes
Em 13/11/2016 07:33, Dimitry Sibiryakov escreveu: > 13.11.2016 10:24, Norbert Saint Georges wrote: >> in new API, How to declare an array of bigint? > >New API does not work with arrays. > > Old API is a client of the new API so you're totally wrong. Adriano -

Re: [Firebird-devel] new API IMetadataBuilder Bigint[1:100]

2016-11-13 Thread Dimitry Sibiryakov
13.11.2016 10:24, Norbert Saint Georges wrote: > in new API, How to declare an array of bigint? New API does not work with arrays. -- WBR, SD. -- Developer Access Program for Intel Xeon Phi Processors Access to I

[Firebird-devel] new API IMetadataBuilder Bigint[1:100]

2016-11-13 Thread Norbert Saint Georges
Hello all, in new API, How to declare an array of bigint? builder := master.getMetadataBuilder(st,1); builder.setType(st,0,SQL_ARRAY +1); ?? builder.setSubType(st,0, 16); ?? builder.setLength(st,0,100); -- Norbert Saint Georges http://tetrasys.fi --