Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 21:26, Thomas Steinmaurer пишет: >> >>> But still, IMHO it does not explain why additional connect request with >>> SS while running OLTP emul with 100 users are taking considerable time, >>> although they are almost instant with SC? >> >>This is not SS vs SC. This is absence vs pre

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
> 14.11.2016 21:00, Thomas Steinmaurer wrote: > >> But still, IMHO it does not explain why additional connect request with >> SS while running OLTP emul with 100 users are taking considerable time, >> although they are almost instant with SC? > >This is not SS vs SC. This is absence vs presence

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 21:00, Thomas Steinmaurer wrote: > But still, IMHO it does not explain why additional connect request with > SS while running OLTP emul with 100 users are taking considerable time, > although they are almost instant with SC? This is not SS vs SC. This is absence vs presence of suppo

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hi Vlad, > 14.11.2016 20:27, Thomas Steinmaurer wrote: > ... >> So, with 16G RAM and an OLTP emul database with ~ 2,9G, it is still >> recommended with Firebird 3 SS and the shared page cache, to rather use >> a smaller number, lets say 50K and keep the FileSystemCacheThreshold at >> 64K to have t

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 20:27, Thomas Steinmaurer wrote: ... > So, with 16G RAM and an OLTP emul database with ~ 2,9G, it is still > recommended with Firebird 3 SS and the shared page cache, to rather use > a smaller number, lets say 50K and keep the FileSystemCacheThreshold at > 64K to have the file system cac

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

2016-11-14 Thread Dalton Calford
Since we are talking datatypes, I wonder if some other datatypes could be considered. UUID - a native supported UUID type without the need for domain declaration including support for using it in identity type columns. TCP4 or TCP6 (32bit unsigned and 64bit unsigned values). Currently we make du

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hello Vlad, > 14.11.2016 16:09, Thomas Steinmaurer wrote: >> Hello Simon, >> >>> Thomas Steinmaurer wrote Mon, 14 Nov 2016 15:03:41 >>> +0300: >>> Hello, using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. with 16G RAM, spinning disk (7200K) and Xeon 1230

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 16:09, Thomas Steinmaurer wrote: > Hello Simon, > >> Thomas Steinmaurer wrote Mon, 14 Nov 2016 15:03:41 >> +0300: >> >>> Hello, >>> >>> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >>> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) >

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hello Simon, > Thomas Steinmaurer wrote Mon, 14 Nov 2016 15:03:41 > +0300: > >> Hello, >> >> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) >> >> Performance related changes in firebird.conf are:

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Simonov Denis
Thomas Steinmaurer wrote Mon, 14 Nov 2016 15:03:41 +0300: > Hello, > > using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. > with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) > > Performance related changes in firebird.conf are: > > DB Page Size = 8K

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hi, > Hi, > >> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) >> >> Performance related changes in firebird.conf are: >> >> DB Page Size = 8K >> DefaultDbCachePages = 128K (DB specific page buffer

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hi, > using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. > with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) > > Performance related changes in firebird.conf are: > > DB Page Size = 8K > DefaultDbCachePages = 128K (DB specific page buffers = 0) > TempCa

[Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hello, using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) Performance related changes in firebird.conf are: DB Page Size = 8K DefaultDbCachePages = 128K (DB specific page buffers = 0) TempCacheLimit =

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

2016-11-14 Thread Alex Peshkoff
On 11/14/16 01:12, Adriano dos Santos Fernandes wrote: > 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 fro

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

2016-11-14 Thread Thomas Steinmaurer
Roman, Marius thanks. The following seems rather easy/light-weight: http://www.codersnotes.com/sleepy/ Regards, Thomas > I wonder if you can use it under Visual Studio Diagnostic Tools > > https://blogs.msdn.microsoft.com/visualstudioalm/2015/01/16/diagnostic-tools-debugger-window-in-visual-stu

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

2016-11-14 Thread marius adrian popa
I wonder if you can use it under Visual Studio Diagnostic Tools https://blogs.msdn.microsoft.com/visualstudioalm/2015/01/16/diagnostic-tools-debugger-window-in-visual-studio-2015/ On Mon, Nov 14, 2016 at 9:21 AM, Thomas Steinmaurer wrote: > Hello, > > do you have any recommendations what toolse

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

2016-11-14 Thread Roman Simakov
2016-11-14 10:55 GMT+03:00 Roman Simakov : > http://developer.amd.com/tools-and-sdks/opencl-zone/codexl/ Now it's here I guess: http://gpuopen.com/compute-product/codexl/ -- С уважением Роман Симаков Директор департамента развития системных продуктов ООО "Ред Софт" skype: simakov_roman www.red